When I type in 100 a 1 appears, 10000 and 100 appear

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Use Tools|options form menu
Open Edit tab and clear the Fixed Decimals box
best wishes
 
Hi
Thank you for the answer. It worked perfectly. How the decimal tab got set
I've no idea! Anyway - Thank you again
--
Regards
Andy


Bernard Liengme said:
Use Tools|options form menu
Open Edit tab and clear the Fixed Decimals box
best wishes
Click to expand...
 
Back
Top