Bob,

I may have not been clear in my explanation. Column A is aready
formatted that way and does look correct eg

0000005510254

The issue I have is that I lose the leading zero's in Column A. The
formula listed by Ardus provied an accurate fix for Column B into
column C (add the zeros) but I need to do the same on Column A.

So if I have

Column A Column B Column C
0000005510254 00020 000000551025400020

Thanks.