Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    StatusBar says FIX (Excel 2003)

    A user got upgraded from Excel 97 to Excel 2003.
    When she opens Excel the Status Bar at the bottom of the screen says FIX (on the right side).
    When she tries to enter a number in a cell it enters it wrong. If you type 1000000 the cell has 1 in it.
    If you enter 234 the cell has .000234 in it.
    I searched for Status Bar indicators to see what the FIX meant, but was not able to find anything.
    She does not have a Personal.xls. There is no customized Workbook.xlt nor Sheet.xlt.
    There are no macros.
    When we open an old workbook and enter a number, it does the same thing.
    Any ideas?

    Thanks,
    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: StatusBar says FIX (Excel 2003)

    It looks like it refers to FIXed decimal points - see this article at MVPS.org

  3. #3
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: StatusBar says FIX (Excel 2003)

    Leif,

    Thanks! I will go try fixing it. It must have been set prior to the install. The user did not change to this setting.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: StatusBar says FIX (Excel 2003)

    Leif,
    That was it! Thanks so much. I showed the user and she said "Oh Oh I think I did change to that setting". She was thinking it would format the entries to show 6 decimals (I showed her how to do that).
    Thank you so much for pointing me to the website as well as explaining what the problem was.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

Posting Permissions

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