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.

vbastarter wrote:

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