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

R

Roger Govier

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
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top