topic Change to number format while exporting to excel in QlikView

Change to number format while exporting to excel

Wed, 28 Mar 2012 06:57:31 GMT

Hi everyone,

Whenever i export data from chart to excel the data in money format(eg. $101,785.69) of epression is stored as 'number as text format' in excel. Is there any way to store it in number format in excel automatically when exported? I am using QV ver11.

Thanks,

Murali

Change to number format while exporting to excel

graham-crooks — Tue, 22 May 2012 11:39:04 GMT

Hi Murali

I am having the same problem, which is why I found your question here. My data is just sum totals, yet it arrives in Excel (2003/XP) as text. Calculations added in the resulting spreadsheet then don't recognise the data. It seems the answer is to copy the data to the windows clipboard and paste it back into excel by hand, rather than use the 'send-to-excel' button option. I arrived at this conclusion having read this: http://community.qlik.com/message/30509#30509

I have to say that seems a bit silly to me, but at least copy-paste via the clipboard seems to work.

Regards

Graham

Re: Change to number format while exporting to excel

Joaquin_Lazaro — Thu, 20 Sep 2012 13:47:50 GMT

Hi:

It was a QV bug, in the next version it will be solved ... read this pdf

Re: Change to number format while exporting to excel

nboccassini — Fri, 24 Jul 2020 09:40:29 GMT

I've solved with:

Num#(Num(field,'format'))