Number field is exported as text in excel file after export`

[santhosh_k_n]

Hi All,

I am using a pivot table in one of my doc and in dimensions one of the dimension is calculated dimension which is in number format

On exporting to excel, values of the calculated column is presented as text and options it pop outs as follows

Please help on this

[its_anandrjs]

Export to excel works there is no problem you are asking or question about that.

Hope this helps

Thanks & Regards

[Anonymous]

hi Prashant

ive followed the same procedure but it isnt working still. i see text format when exported. could you please help

awaiting your response

thanks

Pancham

[PrashantSangle]

in which version are you trying??

Regards,

[chrigu]

hi,

how can i change this on the qlikview server?

Thanks for the answer!

Chrigu