topic Re: Exporting to Excel changes Date format to Text String?? in QlikView

Exporting to Excel changes Date format to Text String??

alkesh_sharma — Mon, 26 Jan 2026 18:19:17 GMT

Hello Experts,

I am facing an issue since yesterday. One of my reports have date columns and are in format 'DD-MM-YYYY' but when this reported is exported to excel the date is converted to Text string, which makes it unusable for further calculations.

I have tried every possible way which i could think of and I am sure that this is a bug. I want a confirmation from you guys.

Thanks,

Alkesh

Re: Exporting to Excel changes Date format to Text String??

amit_saini — Wed, 24 Dec 2014 11:59:14 GMT

Alkesh,

Check below:

http://community.qlik.com/message/684314#684314

Thanks,
AS

Re: Exporting to Excel changes Date format to Text String??

PrashantSangle — Wed, 24 Dec 2014 12:12:09 GMT

Hi,

Go to Help tab->Click on About Qlikview (You get new window)->right click on Qlikview Icon (left bottom)->You get setting window->select ExcelExportMixedAsText->set its value to 0 from 1

Regards

Re: Exporting to Excel changes Date format to Text String??

alkesh_sharma — Wed, 24 Dec 2014 16:31:57 GMT

Tried, but not working.

Re: Exporting to Excel changes Date format to Text String??

alkesh_sharma — Wed, 24 Dec 2014 16:32:27 GMT

This was the very first thing I tried, not working

Re: Exporting to Excel changes Date format to Text String??

vivek_niti — Sat, 27 Dec 2014 06:25:59 GMT

which QV Version are you using?

Re: Exporting to Excel changes Date format to Text String??

alkesh_sharma — Sat, 27 Dec 2014 06:27:15 GMT

Hello Vivek

Its, Version 11.0 SR2.

Re: Exporting to Excel changes Date format to Text String??

vivek_niti — Sat, 27 Dec 2014 06:28:40 GMT

this is a bug in this version.

upgrade to QV 11.2SR9.

Regards,