Number stored as text in excel

[srinivasa1]

Hi

I Have  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.  pls help me out.

[Gysbert_Wassenaar]

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 here for an example. Adjusting the formatting in excel manually is probably faster and easier.

[srinivasa1]

Thanks Sir. Is this Bug?

[#4]

Have you tried placing num() around your expression? This is what I've had to do as a work around.

[srinivasa1]

Yes sir, if i changed it as number in report then am not getting any symbol like $

[#6]

How about :  num(yourfield,'$####.##') or so?