Value in cell is truncated

[imported_unknown]

I enter the value 22000 in a cell and it shows at 220, truncated the final two zeros. the cell is formated as general with no custom formating. I'm stumped.

 

[kskinne]

go to the tools menu, select 'options', select the 'edit' tab, and make sure that fixed decimal is NOT checked. does this solve your problem?

HTH
kevin

 

[Mark W.]

BTW, you'll know that Kevin's recommendation applies if you see "FIX" in the lower right-hand corner of the Status Bar.

 

[imported_unknown]

My thanks to Kevin and Mark for the quick response and correct solution.