topic Re: Number stored as text in excel in QlikView https://community.qlik.com/t5/QlikView/Number-stored-as-text-in-excel/m-p/461184#M172173 <HTML><HEAD></HEAD><BODY><P>How about :&nbsp; num(yourfield,'$####.##') or so?</P></BODY></HTML> Tue, 29 Apr 2014 18:08:13 GMT 2014-04-29T18:08:13Z Number stored as text in excel https://community.qlik.com/t5/QlikView/Number-stored-as-text-in-excel/m-p/461179#M172168 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">Hi</P><P></P><P style="text-align: left;">I Have&nbsp; qv11.0 ,now i have a problem when i export a pivot table report to xl if a column contains a value both numeric and text data,wherever numeric data is there am getting "number stored as text" in excel,if i changed it as number in report then am not getting any symbol like $,euro etc.&nbsp; pls help me out. </P></BODY></HTML> Wed, 20 Mar 2013 15:06:57 GMT https://community.qlik.com/t5/QlikView/Number-stored-as-text-in-excel/m-p/461179#M172168 srinivasa1 2013-03-20T15:06:57Z Re: Number stored as text in excel https://community.qlik.com/t5/QlikView/Number-stored-as-text-in-excel/m-p/461180#M172169 <HTML><HEAD></HEAD><BODY><P>Qlikview can't export formatting. So you either get it as text or as numbers without formatting. You could use a macro to export to excel and create the formatting in the macro. See <A _jive_internal="true" href="https://community.qlik.com/message/280316#280316">here</A> for an example. Adjusting the formatting in excel manually is probably faster and easier.</P></BODY></HTML> Wed, 20 Mar 2013 15:26:18 GMT https://community.qlik.com/t5/QlikView/Number-stored-as-text-in-excel/m-p/461180#M172169 Gysbert_Wassenaar 2013-03-20T15:26:18Z Re: Number stored as text in excel https://community.qlik.com/t5/QlikView/Number-stored-as-text-in-excel/m-p/461181#M172170 <HTML><HEAD></HEAD><BODY><P>Thanks Sir. Is this Bug?</P></BODY></HTML> Wed, 20 Mar 2013 15:28:08 GMT https://community.qlik.com/t5/QlikView/Number-stored-as-text-in-excel/m-p/461181#M172170 srinivasa1 2013-03-20T15:28:08Z Re: Number stored as text in excel https://community.qlik.com/t5/QlikView/Number-stored-as-text-in-excel/m-p/461182#M172171 <HTML><HEAD></HEAD><BODY><P>Have you tried placing num() around your expression? This is what I've had to do as a work around.</P></BODY></HTML> Wed, 20 Mar 2013 15:35:14 GMT https://community.qlik.com/t5/QlikView/Number-stored-as-text-in-excel/m-p/461182#M172171 2013-03-20T15:35:14Z Re: Number stored as text in excel https://community.qlik.com/t5/QlikView/Number-stored-as-text-in-excel/m-p/461183#M172172 <HTML><HEAD></HEAD><BODY><P>Yes sir, if i changed it as number in report then am not getting any symbol like $</P></BODY></HTML> Wed, 20 Mar 2013 16:17:52 GMT https://community.qlik.com/t5/QlikView/Number-stored-as-text-in-excel/m-p/461183#M172172 srinivasa1 2013-03-20T16:17:52Z Re: Number stored as text in excel https://community.qlik.com/t5/QlikView/Number-stored-as-text-in-excel/m-p/461184#M172173 <HTML><HEAD></HEAD><BODY><P>How about :&nbsp; num(yourfield,'$####.##') or so?</P></BODY></HTML> Tue, 29 Apr 2014 18:08:13 GMT https://community.qlik.com/t5/QlikView/Number-stored-as-text-in-excel/m-p/461184#M172173 2014-04-29T18:08:13Z