How do I disable the autodate feature in Excel?

[Bubafat]

When I imput something like "5-4" into a cell (remove "."), I want it to stay 5-4, but it autoformats to "4-May"! How can I turn this feature off so I can put hyphenated numbers into a cell?

Thanks.

 

[AnotherHiggins]

The quickest way that comes to mind is to enter:
[COLOR=blue white]'5-4[/color]
The apostrophe at the begining won't show once you press enter, it just tells excel that you are entering a text string, not a number.


[tt]-John[/tt]
________________________
To get the best answers fast, please read faq181-2886

 

[KenWright]

Assuming you are entereing data into a list, then just format that column as text fisrt, then enter exactly as you have been. If one off entries in random places then use John's suggestion.

Regards
Ken.............

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
---------------- Click here to help the tsunami victims ----------------