Adding 0's in front of string to equal a fixed number of characters

[tdyl1969]

Hi:

I have numerous cells that have to be 18 characters in length. Each cell has characters that currently could be 8 in one cell and 12 in another. Is there a forumla that I can add 0's in front so that in total the cell is 18 characters long?

[NBVC]

Try:

=TEXT(A1,REPT(0,18))

[tdyl1969]

That worked and thanks for the quick response

[ChemistB]

If the cell is a number, NBVC's answer will work. If it's a string, try

=REPT("0", 18-LEN(A1))&A1