numbers in cells are automatically divided by 100. Not a format s.

G

Guest

Intergers entered into the worksheet (even in previous worksheets set up
prior to the problem) are divided by 100. Example: 1 becomes 0.01, While 1.0
remains as entered. I don't believe it's in the cell formatting as the number
shown in the formula bar is not 1 but 0.01, while 1.0 is shown as such.
 

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

Why are my cell being divided by 100? 2
numbers are being divided by 100 on leaving cell 4
Number entered in cell getting always divided by 100 ! 5
Input numbers appearing incorrectly on spreadsheet 2
Number entries are automatically divided by 100 - Excel 2003 1
excel not recognising numbers containing 0.1calculated by formulas 4
Number automatically divided by 100, why? 4
Typed numbers are divided by 10 (Excel 2007) 2

Top