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

1. ## 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. ## 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. ## 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. ## 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. ## 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. ## 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. ## 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. ## 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
•