topic Re: Number Format as text in QlikView

Number Format as text

Mon, 26 Jan 2026 18:19:17 GMT

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

Re: Number Format as text

maxgro — Sun, 01 Nov 2015 18:11:34 GMT

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

Re: Number Format as text

Wed, 04 Nov 2015 09:03:05 GMT

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.

Re: Number Format as text

vipin_mishra479 — Wed, 04 Nov 2015 09:30:30 GMT

Wright your exp like

num(sum(Amount),0.00)

Re: Number Format as text

punitpopli — Wed, 04 Nov 2015 09:33:06 GMT

Hi CombealCIC‌,

Try with Num(#,##0.00%)

Thanks,

Punit

Re: Number Format as text

Kushal_Chawda — Wed, 04 Nov 2015 09:35:32 GMT

Please post the sample application

Re: Number Format as text

Wed, 04 Nov 2015 09:52:27 GMT

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.

Re: Number Format as text

maxgro — Fri, 06 Nov 2015 12:48:52 GMT

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)