quick question
Either:
Pre-format the cell as TEXT
Precede the entry with an apostrophe (which will not be displayed in the
cell): '2-3
--
Biff
Microsoft Excel MVP
"Fady" wrote in message
...
Hello,
I would like to know guys how to stop excel from automatically converting
my
numbers into dates. I type "2-3" in a cell, and whenever I hit enter or
next,
I found it changed to 2-3 February. How can I stop that?
Thanks for yoru help
|