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.
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.
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
[email protected]HIS
"Buckwildbill" <[email protected]> wrote in message
news:[email protected]...
>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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks