When I enter numbers, they show up as dates
Precede them with an apostrophe ' or preformat the cell as text,
This helpfulness from Excel has always annoyed me guessing that anything
with a hyphen or a slash must be a date.
--
Regards,
Peo Sjoblom
"hungrypo" wrote in message
...
I need to enter the following value: 1-99
Whever i enter it, excel changes it to Jan-99. I have tried formatting
the
cell to the general format, different number formats, etc., but the same
thing keeps happening. I do not want to change the format to "text" in
case
i need to make graphs/charts from the data. Any help would be much
appreciated. Thank you!
|