wrong number appears

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

Guest

When I type in the number 2, it appears at 0.02 in the spreadsheet. I have tried to change the formatting, but that does not work. Any suggestions?
 
When I type in the number 2, it appears at 0.02 in the spreadsheet. I have tried to change the formatting, but that does not work. Any suggestions?
Click to expand...

Tools/Options/Edit and DEselect Fixed Decimal Places


--ron
 
You must log in or register to reply here.

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

How to use Text functions? 2
Looking at alternatives 1
whole numbers showing as a decimal 4
Cell Input ~ Display 2
Help with normal distribution, generating ratios for bell-shape cu 5
Entering numbers - doesn't work right 2
How to subtract a number from a Mergefield? 0
Excel Typed text appears in wrong cell 0

Back
Top