Exporting to Excel - Formatting - Qlik Community

dinicholls · ‎2016-10-11

Hi All,

I have a field which is sending me potty!!

I want to export a table to excel. I have a field that contains both text and numbers. Whenever I export this table the number come through as text, is there any way to stop this?

I've tried formatting it to number, also in the 'Settings -> User Pref -> Number formatting' as every option, but no luck.

Is it because there is text and numbers in there?

Is there any way to export a mixed field that excel will recognise as numbers when exported?

Thanks

Di

Anil_Babu_Samineni · ‎2016-10-11

How the values showing, Can you copy the values i mean text and number from your field

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

beck_bakytbek · ‎2016-10-11

Hi Diane,

Check this: QlikTip #32: Exporting multiple QV objects to a single Excel document

here you can find a macro, with this macro are you able to export into Excel your Data in table-Format, and your data will be recognised as numbers.

i hope that helps to resolve your issue

beck