Use Tools|options form menu
Open Edit tab and clear the Fixed Decimals box
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"AndyB" wrote in message
...
Hi

When I type in 100 I get a 1 appearing in a cell. If I type in 1 then .01
appears in a cell. The cells are formated as number with 2decimal places.
If I set format to percent, I type in a 1 and 1.00% is shown.
The numbers I'm typing in appear to be divided by 100.
Any suggestions

--
Regards
Andy