More Leading Zero Woes

[JeffK627]

Hi All,

I have an Excel spreadsheet with a product code that has leading zeroes. If I convert the column format to text, the zeroes go away. If I add an apostrophe at the beginning, either manually or in a macro, the zeroes go away. I need to export this data into an Access database using VBA and I need to preserve those leading zeroes. I won't get to do manual intervention along the way. Any help will be much appreciated!

 

[JeffK627]

Bump.

 

[shg]

=text(A1, "000...however many you need")

Then you can paste that as values over the original data.

 

[JeffK627]

I'll try that, thanks!

 

[shg]

Holler back if you have a problem -- good luck.