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

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.

Tools>options>edit and uncheck fixed decimal places

--

Regards,

Peo Sjoblom

"Surveyor" <[email protected]> wrote in message
news:[email protected]...
> 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.