Putting a zero in front of a number

[hahsa]

Hi. If I have a six digit number such as 012345, how do I format the Excel cell so it shows up as 012345 rather than 12345 as it recorrects itself.

Thank you,

 

[VoG]

Select the cells, Format > Cells, on the Number tab click on Custom then enter the format

000000

and click OK.

 

[hahsa]

Okay, I tried that and it isn't working. I followed the following steps:

1. Right click on column
2. Format cells
3. Go to Number tab
4. Click on category Custom.
5. Click on the last type 00000.
6. Press okay.

Am I missing a step?

Thanks,

 

[VoG]

It should be 000000 (not 00000).

 

[hahsa]

Could there be a flaw in Excel? I am definitely using Excel 2007 and I have double checked and the custom is only for five zeros 00000, not six.

 

[VoG]

See if this helps:

 

[Nicky1]

Right click column and format cells as text

 

[fddekker]

Do you still want the number to remain a number (on which you can do a calculation?) If it is, you have to use the custom formatting as per the previous posts.

If you don't, a quick cheat is to just start with an apostrophe. '

'0123456

 

[Scott Huish]

Could there be a flaw in Excel? I am definitely using Excel 2007 and I have double checked and the custom is only for five zeros 00000, not six.

While selecting Custom shows a lot of formats in the list box, you can type your own in the box that says Type:

Replace whatever is in that box with 000000