EXCEL CELLS DIVIDE CONTENT BY 100 WHEN ENTERED

  • Thread starter frustrated by excel
  • Start date
F

frustrated by excel

office 2003 profesional newly loaded in place of works loaded.

Any numerical entry automatically divides by 100 thus 45 entered is
displayed as 0.45 and 123 as 1.23. No changes or updates have been made to
loaded program
 
G

garfield-n-odie [MVP]

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

Top