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...
 

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

Similar Threads

Excel Typed text appears in wrong cell 0
Input numbers appearing incorrectly on spreadsheet 2
numeric entered automatically divided 100! 1
Why does 100 turn into 1 when I enter it into a cell? 3
Dont display anything above 100% 3
IF Function that returns a percentage 2
numbers are being divided by 100 on leaving cell 4
Data requires decimal point problem. Pls help. 3

Back
Top