topic Re: Export to excel changes date to text in QlikView https://community.qlik.com/t5/QlikView/Export-to-excel-changes-date-to-text/m-p/1083911#M918712 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the same problem. I am using QV 12.10 SR 6.</P><P></P><P>We use a pivot table which provides data for other excel sheets. If I use the workaround my formulas will no longer work because you get one big column:</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/188695_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>So A2 has the date but A3 - A7 don't .. same with A9-A22.</P><P></P><P>Any ideas on that?</P><P></P><P>In QV 11 SR2 there was a similar problem which was mentioned to be a bug: <A href="https://community.qlik.com/thread/146745">Export to excel changes the date to text format</A></P><P>So is this a bug with QV 12 / 12.10?</P><P></P><P>Regards</P><P>Tamara</P></BODY></HTML> Wed, 03 Jan 2018 10:51:08 GMT t_witzgall 2018-01-03T10:51:08Z Export to excel changes date to text https://community.qlik.com/t5/QlikView/Export-to-excel-changes-date-to-text/m-p/1083910#M918711 <HTML><HEAD></HEAD><BODY><P>Hello Experts,</P><P></P><P>I am using QlikView version 12 SR1. I am still having trouble when you choose export to excel, it changes date to text.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/123694_Capture.PNG" style="height: auto; width: auto;" /></P><P></P><P>I know the work around to right click and copy full table to clip board and paste to excel sheet. But what about on the access point.</P><P></P><P>Any help is appreciated. Have a good one!</P><P></P><P>Thank you,</P><P>Parth</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Export-to-excel-changes-date-to-text/m-p/1083910#M918711 2020-11-25T16:16:04Z Re: Export to excel changes date to text https://community.qlik.com/t5/QlikView/Export-to-excel-changes-date-to-text/m-p/1083911#M918712 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the same problem. I am using QV 12.10 SR 6.</P><P></P><P>We use a pivot table which provides data for other excel sheets. If I use the workaround my formulas will no longer work because you get one big column:</P><P><IMG alt="" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/188695_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>So A2 has the date but A3 - A7 don't .. same with A9-A22.</P><P></P><P>Any ideas on that?</P><P></P><P>In QV 11 SR2 there was a similar problem which was mentioned to be a bug: <A href="https://community.qlik.com/thread/146745">Export to excel changes the date to text format</A></P><P>So is this a bug with QV 12 / 12.10?</P><P></P><P>Regards</P><P>Tamara</P></BODY></HTML> Wed, 03 Jan 2018 10:51:08 GMT https://community.qlik.com/t5/QlikView/Export-to-excel-changes-date-to-text/m-p/1083911#M918712 t_witzgall 2018-01-03T10:51:08Z