Number entries are automatically divided by 100 - Excel 2003

C

Chuck

For some mystical reason, all of my numerical entries into an Excel
2003 spreadsheet are being divided by 100. For example, if I enter
1025, the number 10.25 will appear in the cell.

This "divide by 100" situation happens on ALL of my spreadsheets -
even ones that were working fine previously.

To my knowledge, I have not made any changes to the program settings.

Any help is appreciated.

Chuck
 
R

Rick Rothstein

Click Tools/Options on the menu bar, select the Edit tab and remove the
check mark from the checkbox that is labeled "Fixed decimal".

Rick Rothstein (MVP - Excel)




"Chuck" wrote in message

For some mystical reason, all of my numerical entries into an Excel
2003 spreadsheet are being divided by 100. For example, if I enter
1025, the number 10.25 will appear in the cell.

This "divide by 100" situation happens on ALL of my spreadsheets -
even ones that were working fine previously.

To my knowledge, I have not made any changes to the program settings.

Any help is appreciated.

Chuck
 

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

Typed numbers are divided by 10 (Excel 2007) 2
Solving two equations with known exponent 5
Number automatically divided by 100, why? 4
Number entered in cell getting always divided by 100 ! 5
Excel divides every number by 100 upon manual data entry 2
Excel 08 divides numbers by 100 2
Numbers are automatically divided by 100 and I can't turn it off 3
number format in excel 3

Top