Text converting to date when exporting to Excel

  • Thread starter Thread starter Tray
  • Start date Start date
T

Tray

I have a report, which has a Tax Year field. The field is text is of the
format '08/09'. It appears fine throughout Access but when I export the
report to Excel, it converts the text into a date and I get the number
equivalent (ie. 40064 for 08/09). Is there a way to prevent this from
happening?
 
My guess would be that the field in Excel is set to date and it is converting
the text. Can you convert the datatype of the field in Access to date/time?
 
An alternative:

1) Use a query as the source of the export and include all of the
fields necessary with the change listed below.

2) in place of just selecting the Tax Year change it to the following:

Tax Year:"'" & [tablename]![Tax Year]

(the part that looks like a whole bunch of ' is simply a
doublequote & single quote & doublequote.)

This should tell Excel to treat it as a left justified alphabetic
field and not a date.


Ron
 
Back
Top