I have a list of number, various number of digits in each cell. is there a function that I can say "put preceding zeros totaling 20 characters" so each cells has 20 characters with my original number plus preceding zeros.

thanks
Tom