in excel why do numbers entered get divided by 100?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel was working fine last time I used it, but now if I type in for instance
5000, it puts 50 in the cell and on the formula bar, and calculates etc. as
50. I have tried changing formatting, but this doesn't make any differnce
 
In Excel, click on Tools | Options | Edit | uncheck the "Fixed decimal
places" box | OK.
 
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

Number automatically divided by 100, why? 4
numeric entered automatically divided 100! 1
Excel automatically divides number by 100 3
Why does Excel auto-divide numerical inputs by 100? 1
Numbers divided by 100 3
Excel automatically dividing value by 100... 2
numbers are being divided by 100 on leaving cell 4
Dont display anything above 100% 3

Back
Top