Exporting to excel as number

[Anonymous]

Hi!

I have a teble with an expression containing two different number formattings (created as variables) depending on the value in the dimension. Expressions looks something like this:

=if(something,num(expression1,vNumberFormat),num(expression2,vPercentFormat)).

I have set ExcelExportMixedAsText to 0 and in Document Properties field is set as number.

When exporting the table to excel I am getting General format which is not ok. How can I get Qlik to export it as Number?

Thank you!

[vardhancse]

Export to excel only exports the data, not the formatting. You can create a macro that first exports the data and then in excel adds the formatting

[vardhancse]

Change ExcelExportMixedAsText to 1 instead of 0