type in 4-7 changes to 38814
Thank you I was going crazy! Have a great day
--
flojoe
"Niek Otten" wrote:
Excel thinks they're dates.
Precede the codes with an apostrophe. It will not show.
--
Kind regards,
Niek Otten
"fkistner" wrote in message ...
| Help! I am typing into cells numbers like 0-3, 4-7, 8-15, 16-30 and the 4-7
| & 8-15 turn into numbers like 38814 --- I have looked at the formatting and
| it is the same as the 0-3, yet it automatically changes to something strange
| like 38814 --- what is going on? Thanks!
| --
| flojoe
|