1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

HELP with Microsoft Excel - Deleting my "0" Number at start

Discussion in 'Windows - Software discussion' started by acorrea4, Feb 8, 2008.

  1. acorrea4

    acorrea4 Regular member

    Joined:
    Jul 3, 2007
    Messages:
    101
    Likes Received:
    0
    Trophy Points:
    26
    Im having trouble with a spreadsheet I have. It has all kinds of information on it, but when I enter digit values starting with the number "0" it erases the "0" and only keeps the next number!!!
    Does anyone know why?
     
  2. silk42

    silk42 Regular member

    Joined:
    Dec 21, 2007
    Messages:
    591
    Likes Received:
    0
    Trophy Points:
    26
    This is normal. However, if you need to have a leading zero, there are a few options. If you don't need to do a calculation on the number, for example, it's an account number, then you can simply place a single quote at the beginning of the number. If you do need to perform calculations on the number, then read the following article from Microsoft.
    http://support.microsoft.com/kb/81518
     
  3. acorrea4

    acorrea4 Regular member

    Joined:
    Jul 3, 2007
    Messages:
    101
    Likes Received:
    0
    Trophy Points:
    26
    Thanks alot, the "'" helps out, but a little green check comes out in the upper-left corner. Its not a big deal, but it gets the job done!!!! Thanks again.........
     

Share This Page