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.