Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Feb 2004
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    formatting cells (2002)

    I am creating a worksheet with basic numbers in it. I just want to type 4 in a cell, 3 in another cell. What's happening is after I type the number instead of it appearing as 4 or 3, it appears as 0.04 or 0.03. I have checked the formatting cells box and I have it formatted for number which shows just a 4; however, if I look at the formatting for general it is showing 0.04. I cannot get it to change. I have looked under ToolsOptions and cannot find any kind of switch or anything to get it to change. I went to a few other PCs and tried it and it is working correctly on them. However, on mine it is not formatting correctly. Can someone help. I have used Excel for many years and have never run into this before.

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

    Re: formatting cells (2002)

    Select Options from the Tools menu. Click on the Edit tab in the dialog box. Take the check mark from in front of the "Fixed Decimal" option.
    Legare Coleman

  3. #3
    Lounger
    Join Date
    Feb 2004
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    36
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: formatting cells (2002)

    That was it! Thank you so much. I knew it had to be some sort of setting, but I just couldn't figure it out. I don't remember turning that on. Could it have been activated by something else I did?

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

    Re: formatting cells (2002)

    VBA code could turn that on, but that is unlikely.
    Legare Coleman

Posting Permissions

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