Issue in excel export// data not coming in number format

[jyothish8807]

Hello All,

I have a straight chart , in which i am showing data as both (%, and as normal number) and it is working fine is QlikView.

But when i export the table into excel the data comes in text format in excel.

Please find the attached dummy application. I am using "pick (match" in my scenario to meet my requirements.

Any suggestions and help will be really appreciated.

Regards

KC

[#2]

I have QV release 11 SR8. Expression is set to fixed number with 2 decimals that is exported using macro to excel cells with format  number with 2 decimals. Any advices are not functioning, expression is exported as text. I can say I am desperate for this product.