Hi Martin:
when I try that it doesn't work because the numbers came from another source
and it doesn't recognize the numbers as values. I tried copy and paste
special to make them values but it's not working. I had to format the cells
as numbers but it drops the leading zero so I'm trying to add it back.

As far as the "macro module "thing I have never done that so I don't even
know where to start.

Isn't there an easier way for me to do this?

Jannie

"MartinW" wrote:

Hi Jannie

If they are all going to be 13 digits then you could format the
cells as custom 0000000000000

HTH
Martin