topic Re: Retain Number Format when Exporting to Excel in QlikView https://community.qlik.com/t5/QlikView/Retain-Number-Format-when-Exporting-to-Excel/m-p/776305#M1036511 <HTML><HEAD></HEAD><BODY><P>Can you please attach a sample QVW?</P></BODY></HTML> Mon, 12 Jan 2015 20:11:17 GMT reshmakala 2015-01-12T20:11:17Z Retain Number Format when Exporting to Excel https://community.qlik.com/t5/QlikView/Retain-Number-Format-when-Exporting-to-Excel/m-p/776304#M1036510 <HTML><HEAD></HEAD><BODY><P>I'm looking for a way to retain the number formatting when exporting to Excel.&nbsp; Currently, I have a PivotTable and a Straight Table that are exporting the data formatted visually correct, but the numbers have the apostrophe in front making Excel see them as characters.&nbsp; I have tried changing the document number settings but that did not work.</P><P></P><P>It does seem that this only happens on Dimensions.&nbsp; The Expressions seem to be formatted correctly and seen as numbers in Excel.</P></BODY></HTML> Mon, 12 Jan 2015 20:09:24 GMT https://community.qlik.com/t5/QlikView/Retain-Number-Format-when-Exporting-to-Excel/m-p/776304#M1036510 cranium144 2015-01-12T20:09:24Z Re: Retain Number Format when Exporting to Excel https://community.qlik.com/t5/QlikView/Retain-Number-Format-when-Exporting-to-Excel/m-p/776305#M1036511 <HTML><HEAD></HEAD><BODY><P>Can you please attach a sample QVW?</P></BODY></HTML> Mon, 12 Jan 2015 20:11:17 GMT https://community.qlik.com/t5/QlikView/Retain-Number-Format-when-Exporting-to-Excel/m-p/776305#M1036511 reshmakala 2015-01-12T20:11:17Z Re: Retain Number Format when Exporting to Excel https://community.qlik.com/t5/QlikView/Retain-Number-Format-when-Exporting-to-Excel/m-p/776306#M1036512 <HTML><HEAD></HEAD><BODY><P>Can't you just replace these dimensions with expressions?</P></BODY></HTML> Mon, 12 Jan 2015 20:34:02 GMT https://community.qlik.com/t5/QlikView/Retain-Number-Format-when-Exporting-to-Excel/m-p/776306#M1036512 Anonymous 2015-01-12T20:34:02Z Re: Retain Number Format when Exporting to Excel https://community.qlik.com/t5/QlikView/Retain-Number-Format-when-Exporting-to-Excel/m-p/776307#M1036513 <HTML><HEAD></HEAD><BODY><P>Exactly right. I’m not sure why I didn’t try that! Thank you.</P></BODY></HTML> Tue, 13 Jan 2015 12:36:46 GMT https://community.qlik.com/t5/QlikView/Retain-Number-Format-when-Exporting-to-Excel/m-p/776307#M1036513 cranium144 2015-01-13T12:36:46Z