When I type in a number, in excel like 23. It shows up as 0.23

D

Dusty

even if i open up a new sheet it still does the same thing. is there any
thing i can do to correct this?

thanks.
 
G

garfield-n-odie

In Excel, click on Tools | Options | Edit | uncheck the "Fixed
decimal places" box | OK.
 

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

Similar Threads

Paragraph numbering in Word 1
Disable Outlook AutoCorrect with GPO 0
Word 2007 flash screen upside down and Word2007 cannot be used 0
ASK Field Formatting 1
Section and Page numbering 0
Access 2002 change report header text 0
Uninstalling H&S 2010 after installing 2019 3
Visio 2019 crashes when attempting to open drawing. 0

Top