Retaining leading & trailing zeros

I have leading and trailing zeros in my Access 2K MDB file and am exporting it to Excel. Is there a way to program the export to Excel from an Access 2K database so that the format automatically retains the leading and trailing zeros without having to format it manually in Excel. There is a export function made for exporting to Excel automatically and when the file is retrieved, the formatting is gone. I would like to retrieve the Excel file with the formatting in tact. Thank you.