In article , Claus Busch
writes
Hi Colin,

Am Thu, 28 Nov 2013 19:13:23 +0000 schrieb Colin Hayes:

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?

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


Regards
Claus B.

Hi Claus

OK that's entirely perfect.

Thanks Claus.

^_^