Exporting to Excel - Formatting

[dinicholls]

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]

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

[beck_bakytbek]

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