Why not just format the column as 000000?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"SITCFanTN" wrote in message
...
I'm converting an access report to excel and when I do, it is dropping the
leading zeros in column D and E. I need to write a macro to put the zeros
back in but my problem is that not every cell needs the zero added. Every
cell should be 6 alpha-numeric characters. If the data in the cell is
only 4
characters, I need to add 2 leading zeros or if there is only 2
characters, I
would need to add 4 leading zeros. My spreadsheet very lengthy so I need
a
macro to add the zeros, any help you can give me is appreciated, thank
you.