SSRS export to excel and retain data format

Question

User-1132163444 posted

Good day,

may i ask if there is a way to export SSRS reports to Excel and still retain the correct data type?
ex. Date field when exported to excel should still be a date field, same with decimal or integers.

maybe a SSRS event/function that is called only if a report is exported excel and inside is a code that will render the fields data type properly?

I hope someone can enlighten me with this,

Thanks

Answer 1

User665608656 posted

Hi johnjalani,

Based on my research , it seems by design ,whatever format  in report ,when export to excel ,it could be changed to custom or general .

You could change the cell format manually in excel via right click->Format Cells -> Number ->Date.

Or you could export as csv file , it could remain your format.

keep date cell format in excel after export from SSRS 2005

Best Regards,

YongQing.