Text field on report export to Excel as serial nbr of date

C

Cyndy

Data on Access report are numbers with dashes. These are
project numbers not dates and the data type is text. When
report is exported to Excel, the data are converted to
serial number of date.

Examples
Access Data Excel
002-00001-003 37653
002-00004-002 37291
002-00004-003 37656
002-00004-004 38021

37653 is the serial number for 2/1/2003

I tried Analyze It With Excel and still got the same
problem.

Does anybody know the cause and solution to this problem?

Thanks,
Cyndy
 
Top