Export QlikSense table to Excel - date values before 01/01/1900 do not appear correctly

[maprinci]

Hello,

I am trying to export a basic QlikSense table to Excel, and I have tried several different date formats but have been unable to get dates before 1900 to appear correctly.  When I export these dates, they just appear as ###########.

Any suggestions are appreciated.

Thank you!

[Anonymous]

Yup it is an Excel quirk.

Have a look at this

https://www.reddit.com/r/excel/comments/4dshd3/cant_seem_to_get_dates_from_before_1900/