View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Is it possible to get Excel to stop formatting text as a date?

No


--


Regards,


Peo Sjoblom



"PeteeWJ" wrote in message
...
Is there any way to make Excel stop automatically formatting text as a
date?
Specifically I want to be able to type 4-6 without it converting it to a
date, and I don't want to have to type an apostrophe before everything.
Is
there a way to just turn this auto formatting off, besides formatting the
cells as text before hand?