Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Change to number format while exporting to excel

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

1 Solution

Accepted Solutions
joaquinlr
Specialist II
Specialist II

Hi:

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

View solution in original post

3 Replies
graham-crooks
Contributor III
Contributor III

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

joaquinlr
Specialist II
Specialist II

Hi:

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

View solution in original post

nboccassini
Partner
Partner

I've solved with:

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