Thread: quick question
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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