I am sure I must be doing something wrong but here it is:

I import an excel spreadsheet that has dates in the format mm/dd/yyy.

The receiving table in access has a date field set to mm/dd/yy, which
is what I want. The dates are now displayed with a two digit year. The
problem comes when I export the results to excel. When I open the
spreadsheet the dates are back to mm/dd/yyyy again!


Can I force excel to obey me? and keep the dates in mm/dd/yy format?
Perhaps by some workaround to change the field to text or something
before the export?

Thanks in advance for any assistance.


Neil