Thread: howdo I turn off default that automatically changes 8-4 to Aug-4?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR
 
Posts: n/a
Default howdo I turn off default that automatically changes 8-4 to Aug-4?
Type an apostrophe before the 8, or pre-format the cell as TEXT

Vaya con Dios,
Chuck, CABGx3



"Don" wrote:

When I type 8-4 or 8/4 in a cell, these characters automatically change to
Aug-4 when I move to the next cell. Obviously there is a default at work in
Excel 2003 that is doing this. Is there a way to turn off this default or am
I forced to contiually text format the cells into which I type characters
such as these?
Reply With QuoteReply With Quote