help!! 1000 appears as 10 in excel

  • Thread starter Thread starter Help!! 1000 appears as 10 in excel
  • Start date Start date
H

Help!! 1000 appears as 10 in excel

When I type 1000 it appears as 10. Can anyone help
 
Tools>Options>Edit.

Uncheck "fixed decimal places"


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

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

vlookup 3
Extracting Data From The Right of a Cell 1
excel help please. Urgent!! 2
formula help 2
Access Running Balance in Access 1
pvt table field settings! 1
FV Function result is unexpected. 8
Formulas Still Not Working 5

Back
Top