I posted this on the Access Discussion Group board but I think it is really a
Excel issue. Please keep in mind that I do not want the user to have to
reformat the cells as that may be above their abilities.

I have a MS Access report that I want the user to be able to export to Excel
using the MS OfficeLinks button on the report tool bar. When I export the
data I have two issues occurring:

1) Item data (text in access) 6610014887408 is being displayed as scientific
notation

2) Item data (text in access) 005656406 is having the zeros removed from the
front

Is there a way around this so the user does not have to manually reformat
the Excel spreadsheet? When you export using OfficeLinks it automatically
creates a new spreadsheet so setting the cell formatting in advance is not an
option.