Access Report to Excel - Date and Time Formats Lost

S

SLO

Any way to keep date and time formats when sending an Access 2003 report as
an Excel file? The controls on the Access report are formatted for short
date and medium time.
Rich Text Format works perfectly, but my recipients prefer Excel so they can
import/manipulate it on their end.
This is something we send out monthly to 30+ distinct recipients. I want to
avoid us manually formatting the 30+ individual files before sending, as well
as asking the recipients to format it once they receive it.

Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top