Input numbers appearing incorrectly on spreadsheet

  • Thread starter Error in inputting numbers into excel
  • Start date
E

Error in inputting numbers into excel

When I type a number into excel the number appearing in the cell is divided
by 100.
i.e. if I input 1 the number in the cell is 0.01
but if I input 1.0 the number is correctly displayed as 1

Any ideas, it driving me to drink
 
G

Gord Dibben

Tools>Options>Edit.

Clear the checkbox at "Fixed Decimal Places"


Gord Dibben MS Excel MVP
 

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