Thread
:
How do I stop Excel from changing numbers into a date?
View Single Post
#
2
Nick Hodge
Posts: n/a
Pre-format the cells as text or pre-fix entry with a single apostrophe. (It
will not show but will stop the conversion)
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
"Buckwildbill" wrote in message
...
I would like to type in 1-3 but it keeps getting turned into 3-Jan. I have
turned off every option in excel that I can find but it still keeps
happening.
Reply With Quote