Excel-Input numeric value in cell, it shows up as 1/100th of entry
I must have some cell formatting setup somewhere or something strange is
going on....
In a cell, I can enter a value of "1". Once I hit return to exit the cell,
the value in the cell is shown as "0.01", not "1". This is driving me crazy
and I have had miscalculating spreadsheets due to this issue.
To re-iterate, when I put a numeric value in a cell, it shows up as 1/100th
of the value.
Any suggestions to correct this.
Darin
|