topic Export to Excel in QlikView https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/413048#M153688 <HTML><HEAD></HEAD><BODY><P>When I export a table to excel numeric columns are exported as text.</P><P></P><P></P><P>On the document "QlikView 11 SR2 Beta Release Notes" there is a bug number related to this problem</P><P>46971 Exporting excel as numbers does not work correctly.</P><P></P><P>Environment: QV 11 SR2 64-bit + Windows XP Pro x64 v 2003 SP2 + MS Office 2010 32 bits</P><P></P><P>I've tested all combinations (54) of Document Preferences Encoding (3x) by User Preferences Number Formatting (3x) and Encoding (3x) and Use Regional settings (2x). 3x3x3x2=54. None of the combinations works fine.</P><P></P><P>Between every preference change a every click on Export to Excel I've closed and open QV ... not only thq qvw document.</P></BODY></HTML> Mon, 15 Oct 2012 07:12:40 GMT Joaquin_Lazaro 2012-10-15T07:12:40Z Export to Excel https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/413048#M153688 <HTML><HEAD></HEAD><BODY><P>When I export a table to excel numeric columns are exported as text.</P><P></P><P></P><P>On the document "QlikView 11 SR2 Beta Release Notes" there is a bug number related to this problem</P><P>46971 Exporting excel as numbers does not work correctly.</P><P></P><P>Environment: QV 11 SR2 64-bit + Windows XP Pro x64 v 2003 SP2 + MS Office 2010 32 bits</P><P></P><P>I've tested all combinations (54) of Document Preferences Encoding (3x) by User Preferences Number Formatting (3x) and Encoding (3x) and Use Regional settings (2x). 3x3x3x2=54. None of the combinations works fine.</P><P></P><P>Between every preference change a every click on Export to Excel I've closed and open QV ... not only thq qvw document.</P></BODY></HTML> Mon, 15 Oct 2012 07:12:40 GMT https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/413048#M153688 Joaquin_Lazaro 2012-10-15T07:12:40Z Re: Export to Excel https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/413049#M153689 <HTML><HEAD></HEAD><BODY><P>Hi:</P><P></P><P>Following the instructions on this article <A href="https://eu1.salesforce.com/articles/Basic/How-to-export-data-to-excel-as-number-in-version-11?popup=true">https://eu1.salesforce.com/articles/Basic/How-to-export-data-to-excel-as-number-in-version-11?popup=true#</A> at the customer portal I've found the way to export numeric fields as numeric cells ... but unformatted.</P></BODY></HTML> Wed, 07 Nov 2012 10:10:20 GMT https://community.qlik.com/t5/QlikView/Export-to-Excel/m-p/413049#M153689 Joaquin_Lazaro 2012-11-07T10:10:20Z