Welcome Guest
Log In | Register )
You last visited January 21, 2017, 4:32 pm
All times shown are
Eastern Time (GMT-5:00)

Excel and leading zeros

Topic closed. 4 replies. Last post 11 years ago by truecritic.

Page 1 of 1
PrintE-mailLink
truecritic's avatar - PirateTreasure
Michigan
United States
Member #22395
September 24, 2005
1583 Posts
Offline
Posted: January 26, 2006, 7:02 pm - IP Logged

I don't use Excel but have seen this mentioned a few times here at Lottery Post.  The fact that Excel won't display leading zeros.  So a pick 3 number such as 012 will only show up as 12.

This is an excerpt from the MS article about it.  Hope this helps the Excel users that didn't know how to fix it.

Typing a Value with Leading Zeros

Because leading zeros are insignificant digits, Microsoft Excel omits them when you type a number, such as 00023, in a cell. In this case, Microsoft Excel applies the General number format.

To type a value with a leading zero, you can use one of the methods described in the previous section to type the value as text, or you can use the following steps to create a custom number format that contains leading zeros.
1.Select the cell range that you want to format.
2.On the Format menu, click Cells. On the Number tab, click Custom.
3.In the Type box, type a zero for each digit in the number. For example, if the number has five digits, type five zeros.
4.Click OK.
If you import a text file or parse text, you can use this procedure after you import or parse the text. You do not need to preformat the entries as text. However, you must preformat numbers that are evaluated as dates, times, or scientific notation.
Here is a link to the article

    Shaggy's avatar - Lottery-063.jpg
    Denver, Pa
    United States
    Member #6601
    August 30, 2004
    336 Posts
    Offline
    Posted: January 26, 2006, 8:04 pm - IP Logged

    Awesome Truecritic Thanks for the info and the site. Tried it and it worked perfect.

      lottaloot's avatar - AvatarZ56
      Redford/MI
      United States
      Member #3396
      January 18, 2004
      4867 Posts
      Offline
      Posted: January 26, 2006, 8:19 pm - IP Logged

      You can also add '012 or '051 or '000 and it will show up without any problems. 

      L ttaL   T

        Snakeyes's avatar - 8579390479 65f71643cf_m.jpg
        Cleveland, Ohio
        United States
        Member #11445
        February 13, 2005
        1303 Posts
        Offline
        Posted: January 27, 2006, 2:48 pm - IP Logged

        Yes! Thanks a million! It worked for me too.

         

        Snakeyes

          truecritic's avatar - PirateTreasure
          Michigan
          United States
          Member #22395
          September 24, 2005
          1583 Posts
          Offline
          Posted: January 28, 2006, 4:56 am - IP Logged

          You are all welcome.
          Glad it was helpful.