When I input a numerical value to a cell, say 12, the cell will appear as
0.12. And indeed the "value" of this cell becomes 0.12 not 12.

How to resolve this problem? I have checked the cell formatting. There is
nothing wrong with it.

Thanks.

On Sat, 11 Feb 2006 19:08:26 -0800, "zhj23"
wrote:

When I input a numerical value to a cell, say 12, the cell will appear as
0.12. And indeed the "value" of this cell becomes 0.12 not 12.

How to resolve this problem? I have checked the cell formatting. There is
nothing wrong with it.

Thanks.

Tools/Options/Edit
Deselect Fixed Decimal Places
--ron

Goto ToolsOptionsEdit tab

Uncheck Fixed Decimal Places

Biff

"zhj23" wrote in message
...
When I input a numerical value to a cell, say 12, the cell will appear as
0.12. And indeed the "value" of this cell becomes 0.12 not 12.

How to resolve this problem? I have checked the cell formatting. There is
nothing wrong with it.

Thanks.

Go to your Tools / Options, click the Edit tab. Uncheck the "Fixed Decimal
Places".

That should do it.



"zhj23" wrote:

When I input a numerical value to a cell, say 12, the cell will appear as
0.12. And indeed the "value" of this cell becomes 0.12 not 12.

How to resolve this problem? I have checked the cell formatting. There is
nothing wrong with it.

Thanks.