when type in a number it autocorrects to a date how do i stop it?
 

when type in a number it autocorrects to a date how do i stop it?
 

Hi

Format the column as General.

If you are typing something with a slash in it, e.g. 1/4, then precede with
a single quote

--
Regards
Roger Govier

"samh" wrote in message
...

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
...