Hi Colin,

Am Thu, 28 Nov 2013 17:15:25 +0000 schrieb Colin Hayes:

I've been using the custom format method 0000000000000 , but find it
'forgets' the zeros when counting the length of the cell contents. This
is causing errors.

why does this not working for you? Or do you need really 13 digits
number and not only the format?

I'm now using

=IF(LEN(A2)=12,("0"&A2),A2)

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


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2