ms access - Report to excel Date format Conversion -

i have report uses single query record source generate report. exporting report excel following code

docmd.outputto objecttype:=acoutputreport, objectname:=strreport, outputformat:=acformatxls, outputfile:=strpath & strtempfile, autostart:=false 

all data in report correct except date, date format displayed genereal number (not sure format)

any appricaited. thanks.

excel displaying date in way excel 'sees it', rather in user friendly date format.

in excel, every date has value number. allows excel perform calculations/do things dates (example - checking days between 2 dates).

if reformat excel doc (right click on random date , click format , change date) you'll find have correct date exported.

probably haven't answered question, if you're doing data dump may not need export formatting (because can show date in date format on report).