padding ?

[vbastarter]

I have a columnn with id numbers
ex:
012
456788
78
.... etc
I would like the final Id to be 10 digits so i would like to pad 0's in the
front eg:
012 -> has to become 0000000012
456788 -> hast to become 0000456788

Is there a function in excel that can achieve this for teh entire column ?

Many Thanks

 

[Dave Peterson]

You can change the number format to "0000000000" (without the quotes) and the
cells will display all those leasing 0's.

Select the column
format|cells|number tab
custom category
type in that long string of 0's
hit ok.

 

[Gary Brown]

You have two options depending on what you are trying to achieve. If you
want the data to be held with the leading zeros then format the column
as text and put a data validation on the cells requesting a text length
of 10 characters.

If you are not bothered with what is actually in the cell, you just
want it to display with 10 numbers, then use a custom formt of
0000000000. This will then display the number 123 as 0000000123