Exporting to Excel

[sthapa]

Hi all

I am having a problem exporting a access report to Excel.
Numbers starting with zero is automatically knocked out when exported to Excel.

is there something I can change on Access that will allow the whole number to be shown in Excel ?

 

[sfreeman@co.mer]

Excel is seeing the imported text that starts with zero as a number, and since no number starts with zero, it is truncated.

I would make sure that the field in Excel is formated as text.

Might even be easier to attach the spreadsheet as an Access table.

HTH