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.

Toolsoptionsedit and uncheck fixed decimal places

--

Regards,

Peo Sjoblom

"Surveyor" wrote in message
...
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.