topic How to keep thousands separator when export to Excel? in QlikView https://community.qlik.com/t5/QlikView/How-to-keep-thousands-separator-when-export-to-Excel/m-p/19278#M3200 <HTML><HEAD></HEAD><BODY><P>Dashboard Layout （include thousands separator）:</P><P></P><P><STRONG>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount</STRONG></P><P>abc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 71,556,234,651.67</P><P>bcd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 61,556,234,651.23</P><P></P><P></P><P>After export to excel, it will be shown like below (thousands separator removed):</P><P></P><P><STRONG>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount</STRONG></P><P>abc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 71556234651.67</P><P>bcd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 61556234651.23</P><P></P><P></P><P>Question: How to keep the number format same with shown in dashboard (include thousands separator) after exported to excel file?</P></BODY></HTML> Thu, 26 Apr 2018 03:24:00 GMT alex_stone 2018-04-26T03:24:00Z How to keep thousands separator when export to Excel? https://community.qlik.com/t5/QlikView/How-to-keep-thousands-separator-when-export-to-Excel/m-p/19278#M3200 <HTML><HEAD></HEAD><BODY><P>Dashboard Layout （include thousands separator）:</P><P></P><P><STRONG>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount</STRONG></P><P>abc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 71,556,234,651.67</P><P>bcd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 61,556,234,651.23</P><P></P><P></P><P>After export to excel, it will be shown like below (thousands separator removed):</P><P></P><P><STRONG>Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Amount</STRONG></P><P>abc&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 71556234651.67</P><P>bcd&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 61556234651.23</P><P></P><P></P><P>Question: How to keep the number format same with shown in dashboard (include thousands separator) after exported to excel file?</P></BODY></HTML> Thu, 26 Apr 2018 03:24:00 GMT https://community.qlik.com/t5/QlikView/How-to-keep-thousands-separator-when-export-to-Excel/m-p/19278#M3200 alex_stone 2018-04-26T03:24:00Z