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

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
 
B

Bernard Liengme

Use Tools|options form menu
Open Edit tab and clear the Fixed Decimals box
best wishes
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top