Results 1 to 8 of 8
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Show a zero at the beginning of a number (2003)

    I know I have to create a custom format - can't remember what to create - mind is blank - help me please . . .

    Want to see 03 in a cell and it needs to be read by Excel as a number.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Show a zero at the beginning of a number (2003)

    Select the cell or cells.
    Select Format | Cells...
    Activate the Number tab.
    Select the Custom category.
    To display a number with 2 digits, using a leading zero if necessary, enter 00 in the Type box.
    Click OK.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show a zero at the beginning of a number (2003

    Scary - I've done that about a thousand time for other people - thank you for saving me - again.

    Aunt Linda

  4. #4
    Star Lounger
    Join Date
    Mar 2002
    Location
    California, USA
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show a zero at the beginning of a number (2003)

    Exactly what I was looking for. How do you do it if you don't always know how many digits there will be in the numbers that may be filled in later?

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Show a zero at the beginning of a number (2003)

    How would you decide whether there needs to be a leading zero if you don't know the number of digits? <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  6. #6
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Show a zero at the beginning of a number (2003)

    If you want to put a leading zero in front of all numbers you can use the custom format:
    "0"0

    You will get things like "01" for 1, 012 for 12, 0123 for 123, etc. Every number will just have a zero added at the beginning, though I wonder why you would need this...

    Steve

  7. #7
    Star Lounger
    Join Date
    Mar 2002
    Location
    California, USA
    Posts
    89
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Show a zero at the beginning of a number (2003)

    we have a workbook that we use all the time for tracking documents that are stored off site. The number represents the box number the document is stored in. I don't think there will be any reason to do anything with these number but there is a formula somewhere in the workbook that refers to these numbers in column 1 so the green triangle indicator that says there is a problem with the contents appeared in all of the cells with a leading zero. This is annoying to the users for some reason.

  8. #8
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Show a zero at the beginning of a number (2003)

    What is the formula expecting?

    Perhaps to keep the leading zero, instead of formatting as discussed earlier in this thread, the cells were formatted as "Text". If they formatted as test they are no longers numbers (formatted as mentioned earlier keeps them as numbers). If the formula expects numbers and the cells have text, it could lead to this "problem"...

    Steve

Posting Permissions

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