try:
=REPT(0,13-LEN(A2))&A2

Hi Claus

OK Thanks again. This works perfectly. I do need 13 solid digit numbers
and not just format.

BTW I find I have a couple of 14 digit numbers in my column which give
#VALUE! Errors. Is there a way to ignore these numbers when running the
REPT formula?


Best Wishes