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