Number Format as text

[#1]

Hello,

I come to you, because I have a problem with a Number Format. when i export my spreadsheet on Excel,

I have formatted my Number with the function Num. '#,###.00%'.

But when send to excel the report, there are some errors about the formatting of the Number. i have to convert my text to Number...

How to solve my problem?

Thanks

[maxgro · Accepted solution]

Hope to understand your question:

it seems if you export to excel a column with the same number format in all the values of that column, in excel you get a number (top 2 examples in image).

If you send to excel a column (red rectangle in image) with mixed format, in excel you get a text

[#3]

Thank you for the answer

Yes I import excel on a column with different formats.

But I do need that the result is excel surt the form of number, not in text.

[vipin_mishra479]

Wright your exp like

num(sum(Amount),0.00)

[punitpopli]

Hi CombealCIC‌,

Try with Num(#,##0.00%)

Thanks,

Punit

[Kushal_Chawda]

Please post the sample application

[#7]

Thanks you, for the answer.

Sorry, I export my QlikView Spreadsheet to excel.

And I used Num(#,##0.00%) for the row with the %.

And Num(#,###.00' ) for the other row.

But I need to use two numbers formats different, cause I want to see in the same column number and pourcentage.

[maxgro]

hope to be wrong but if you use 2 diffferent format in Qlik in the same column, when you send to excel you get a text (in excel)