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

Excel-Input numeric value in cell, it shows up as 1/100th of entry
 

Tools Options Edit clear fixed decimal
--
Gary''s Student - gsnu200752


"DarinMelin" wrote:

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

Excel-Input numeric value in cell, it shows up as 1/100th of entry
 

ToolsOptionsEdit.

Uncheck "fixed decimal places"


Gord Dibben MS Excel MVP

On Wed, 31 Oct 2007 10:40:03 -0700, DarinMelin
wrote:

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