Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Excel 2002 general number format problem

  1. #1
    Guest

    Default

    Hi,

    I've installed Excel 2002, but every time I enter a number in a cell, it gets multiplied by 10. (meaning 7 automatically becomes 70, etc). This is really annoying and it only happens in Excel. Can anybody help me solve this?

    Thanks!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    long shot and can't think how it would have happened, but do you have fixed decimals (tools>options) set to -1?

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    ..and I bet that there's a FIX indicator on the right hand side of your status bar. Choose the Tools | Options... menu command, click on the Edit tab, and uncheck the "Fixed decimal" box.

  4. #4
    Guest

    Default

    Thanks a lot! I did have the fix indicator. It works now fine.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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