Results 1 to 8 of 8
  1. #1
    New Lounger
    Join Date
    Feb 2005
    Location
    Totowa, New Jersey, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    two decimal points not working right (Excel 2003)

    We switched to Office 2003 last week. As an Accountant I key a lot of numbers into Excel Spreadsheets. In Excel 2000 if you entered 3000. and hit enter it would show up as 3000.00. It would work just like a calculator and put the 2 zeros to the right of the decimal point. For some reason in Excel 2003 when I key in 3000. and hit enter it shows up as 30.00. I have the spreadsheet formatted as numbers with 2 decimal points and the thousand separator. This is the same way it was formatted in 2000. Is there something I am missing here? I have checked all the formatting options and other things and can not find anything to make this work the way Excel 2000 did. I am so used to doing it the other way it is becoming a pain and I hoping it is something simple I am missing. Thanks for any help, Bob G

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: two decimal points not working right (Excel 2003)

    Select Tools | Options...
    Activate the Edit tab.
    Clear the Fixed Decimal check box.
    Click OK.

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: two decimal points not working right (Excel 2003)

    Good evening Bob

    I am only a novice myself but I have just done as you say in 2003 and it adds the .00, I don't know why it would not in yours, have you tried selecting 'Custom' and using the 3rd option 0.00 because that also works in mine

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: two decimal points not working right (Excel 2003)

    This is not a formatting issue as it would be extremely difficult if not impossible to divide the entered value by 100 using formatting. The problem here is the Fixed Decimal option under Tools/Options. See Hans' reply earlier in the thread.
    Legare Coleman

  5. #5
    New Lounger
    Join Date
    Feb 2005
    Location
    Totowa, New Jersey, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: two decimal points not working right (Excel 2003)

    Hans, thanks for a response. That will give me my zeros to the right of the decimal point without entering them, but that makes me key in a decimal point in if I want the result to be 145.94. In 2000 with the fixed decimal on you got the zeroes by hitting the decimal point with the whole number and you did not have to enter a decimal point to get the 145.94. This is crazy. There is a service pack that goes with office 2003 that we have tried to download, but I got error messages and have to research them. Maybe it was a bug that is fixed by the service pack.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: two decimal points not working right (Excel 2003)

    Yes, this was a bug in the first release of Excel 2003. As far as I know, it has been fixed in Service Pack 2. The most recent update is Service Pack 3 (released last month).

  7. #7
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: two decimal points not working right (Excel 2003)

    Hi Legare

    I was composing slower than Hans so I had not realised at the time he was answering so by the time my answer hit the board Hans was already posted

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  8. #8
    New Lounger
    Join Date
    Feb 2005
    Location
    Totowa, New Jersey, USA
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: two decimal points not working right (Excel 2003)

    Thanks for all your help. At least I know I am not going crazy. <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15> I will now have to research further the error messages I got when trying to download service pack 3. The original answers I looked at mentioned something about spybot search and destroy (which I have on my computer) or the companies firewall keeping it from finishing downloading and installing.

    Thanks again. Bob G

Posting Permissions

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