View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ron Rosenfeld
 
Posts: n/a
Default Wrong Numerical Input

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