General Question. Leading Zeros

[eddieque]

Is there a way to have a leading zero in a cell. I have an part number for example 0123456. When i enter it into a cell the zero disapears do I have 123456. I need the zero to be displayed.

Thank

 

[phantom1975]

You can convert the number to text by putting an apostrophe in front of the number:

'0123456

 

[TommyGun]

If you just want the 0 to display then change your number formatting to a custom format of: 0000000. This will force there to be 7 digits displayed. If you actually need your number stored as 7 digits, then you'll have to look at the TEXT function.

 

[Joe4]

You can change the format to a custom format of 0000000. That will display a leading zero, but the zero won't actually be in cell (just the displayed format will change).

If you actually want a literal zero retained in your entry, format the column as Text.

 

[eddieque]

Thanks Guys!

20 seconds after i posted this I found my answer!

But MR Excel Rules!!