multicurrency change cell value when export to excel

[#1]

i have a problem.

I work with a multicurrency QV,

we need before to select a currency

in a table we do  price multiplie by the corresponding change and is the corresponding format.

i add(a qvw) whit this, this is not the problem.

We have solved this problem with the following formula:

num(sum(precio)*Cambio,FORMATO)

when change = 1,2134

and format= $#.##0,00  ;$-#.##0,00

this is all right, but if we export this table to excel, the cell value(data) is consider like a text and we can´t do opertations in excel like sum for example...

[Anonymous]

check attached..

hope that helps..

[#3]

It seems to be a solution, even that would fail to keep the currency format when exporting to excel, you would know how?

thanks

[Anonymous]

hi christina

                     have alook at the attached qvw.

regards,

vaibhav

[Anonymous]

hey christina did u get the solution?

[#6]

No, I need to have the table in QlikView with the selected currency format and exporting to excel the field has the currency format and can be added to that format excel cells can not be text, as is in the solution that you sent.

thank you very much