Export table with default format to Excel-numeric format

[jorditorras]

Dear Gurús,

I have a table with some KPI's and I have to set the format as "default format" (the reason is that I'm applying one variable only Works by setting Degalta Format). When exporting to Excel, it appears as Text Format. Is it any way to Export it as numeric format?

Thanks,

Regards

[kuczynska]

Hi,

You can always try to use NUM() in the expression itself. By doing this the Expression Default format will default to the one set in the expression, which is a numeric format.

[jorditorras]

Hi Kuczynska,

Thanks for your message, but I defined all the expressions with NUM() and, (supposedly) as I set the numer format as default, then it still treat the KPI's as text when exporting it to Excel...

Thanks again.

Regards,

Jordi

[kuczynska]

Hi Jordi,

In that case you would have to share your sample qvw so we could have a look at it. Is that possible?