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
Number automatically divided by 100, why? 4
Excel: numbers in cells get divided by 100: all spreadsheets ... 2
All number inputs are divided by 100 ? 2
Number entered in cell getting always divided by 100 ! 5
illegal division by 100 2
Amount is divided by 100 2
numeric entered automatically divided 100! 1

Top