Thread: when type in a number it autocorrects to a date how do i stop it?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default when type in a number it autocorrects to a date how do i stop it?
This white space is where you ask questions.

You did not say what you mean by 'auto corrects' .
If 123 becomes 1.23 then use Options | Tools open the Edit tab and uncheck
the Fixed Decimals box.
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"samh" wrote in message
...



Reply With QuoteReply With Quote