topic Problem when exporting to excel in QlikView https://community.qlik.com/t5/QlikView/Problem-when-exporting-to-excel/m-p/376098#M140184 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have recently migrated from Qlikview 9 to Qlikview 11. I have a problem when exporting data from a app from both Qlikview Desktop and from the webpage.When I export to excel some of my columns that contain numbers and displayed as text so I cant run queries on them. Also dates don't look correct either and cannot be filtered.When exported from a version 9 client this isn't a problem. Has anyone else experienced this? Thanks</P></BODY></HTML> Fri, 30 Mar 2012 07:35:45 GMT 2012-03-30T07:35:45Z Problem when exporting to excel https://community.qlik.com/t5/QlikView/Problem-when-exporting-to-excel/m-p/376098#M140184 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I have recently migrated from Qlikview 9 to Qlikview 11. I have a problem when exporting data from a app from both Qlikview Desktop and from the webpage.When I export to excel some of my columns that contain numbers and displayed as text so I cant run queries on them. Also dates don't look correct either and cannot be filtered.When exported from a version 9 client this isn't a problem. Has anyone else experienced this? Thanks</P></BODY></HTML> Fri, 30 Mar 2012 07:35:45 GMT https://community.qlik.com/t5/QlikView/Problem-when-exporting-to-excel/m-p/376098#M140184 2012-03-30T07:35:45Z Problem when exporting to excel https://community.qlik.com/t5/QlikView/Problem-when-exporting-to-excel/m-p/376099#M140185 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Yes they have changed the export formats.</P><P>You have to override the format for the fields you like to have in different format than text.</P><P>Menu - Document Properties - Tab Number . Here you can see all fields in your app. Choose your field(s) and change default Number Format settings.</P></BODY></HTML> Fri, 30 Mar 2012 10:09:25 GMT https://community.qlik.com/t5/QlikView/Problem-when-exporting-to-excel/m-p/376099#M140185 jerrysvensson 2012-03-30T10:09:25Z Problem when exporting to excel https://community.qlik.com/t5/QlikView/Problem-when-exporting-to-excel/m-p/376100#M140186 <HTML><HEAD></HEAD><BODY><P> Thanks jerry, worked like a charm.</P></BODY></HTML> Fri, 30 Mar 2012 12:48:39 GMT https://community.qlik.com/t5/QlikView/Problem-when-exporting-to-excel/m-p/376100#M140186 2012-03-30T12:48:39Z