Use Tools | Options; open the Edit tab and deselect the "Fixed decimal" box
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Steve" wrote in message
...
Seem to have created a monster. When I type 122 in a cell it displays as
1.22
Any numeric I type ends up with decimal point moved two places to the left
and I can't seem to correct. Is there some obvious formatting that I am
missing?