Entering numbers - doesn't work right

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

Guest

I need help! When I enter numbers, like "-2" or "1", they become "-0.02" and
"0.01". I have no idea why it's doing that. I've looked under "format
cells" but I can't figure out what's wrong. Help me please! Thanks!
 
You have the 'fixed decimal' setting turned on. You should see
'Fix" in the bottom right corner of the Excel screen. To turn
this off, go to the Tools menu, choose Options, then the Edit
tab. There, uncheck "Fixed decimal".
 

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

Back
Top