I want the cell to have 3-4 but it keeps changing it to 4-Mar.
D Dave Peterson Oct 1, 2009 #2 You could either: Preformat the cell as text (format|cells|number tab|Text), then do the data entry. Or you could prefix your entry with an apostrophe: '3-4
You could either: Preformat the cell as text (format|cells|number tab|Text), then do the data entry. Or you could prefix your entry with an apostrophe: '3-4
K KC Oct 1, 2009 #3 first try to change the format of the cell to TEXT and then enter the value. -kc *Click YES if this helps
first try to change the format of the cell to TEXT and then enter the value. -kc *Click YES if this helps
