how to force excel not to change date?

[tgi]

I want the cell to have 3-4 but it keeps changing it to 4-Mar.

 

[Dave Peterson]

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

 

[KC]

first try to change the format of the cell to TEXT and then enter the value.

-kc
*Click YES if this helps