Format your cells using a customer format of
000000

That should do what you want.

HTH,
Paul

"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.