+ Reply to Thread
Results 1 to 3 of 3

Entering numbers - doesn't work right

Hybrid View

Guest Entering numbers - doesn't... 04-23-2006, 09:10 PM
Guest Re: Entering numbers -... 04-23-2006, 09:10 PM
Guest Re: Entering numbers -... 04-23-2006, 09:10 PM
  1. #1
    Zzilly14
    Guest

    Entering numbers - doesn't work right

    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!

  2. #2
    Chip Pearson
    Guest

    Re: Entering numbers - doesn't work right

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


    "Zzilly14" <Zzilly14@discussions.microsoft.com> wrote in message
    news:B767A008-B95B-4D38-99DE-32E232636F18@microsoft.com...
    >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!




  3. #3
    Dave Peterson
    Guest

    Re: Entering numbers - doesn't work right

    Tools|options|edit tab|uncheck fixed decimal places



    Zzilly14 wrote:
    >
    > 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!


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1