Excel export treats qlik text fieds as mixed that causes troubles with long numbers

[#1]

I have a trouble with exporting text fields to Excel using Send to Excel. When the field contain a long number (12 digits or more) the results are displayed in exponential form (like 6.6722E+11). As these are the IDs it is not a good idea to leave them displayed that way. Can I force the export to put such columns in excel in the Text format? Thanks in advance!

[#2]

FIND THIS ATTACHMENT

when u send long numbers to excel, they are implicitly formatted to text.

try send to excel by right clicking on listbox. place the cursor on 1 of the rows in excel and see the message

[#3]

find the screen shot

[#4]

No difference for me whether right-click or upper right angle icon. What am I doing wrong? !

[#5]

PS: I'm exporting from a straight table chart, if it makes any difference...

[ashfaq_haseeb]

Hi Alexander

Try to convert your field to number and export as shown below.

num(yourfield,'#,###,###,#00')

Regards

ASHFAQ

[#7]

The contents of the field is 95% numbers, but the other 5% contain letters and starting zeros that must be preserved. So I bet I will have errors in convertation in the 1st variant and leading zeros truncation in the second one.

[ashfaq_haseeb]

Hi

can you post some sample data

Regards

ASHFAQ

[ashfaq_haseeb]

Hi

you can try by converting it to text

text(yourfield) as Field

Regards

ASHFAQ

[#10]

Tried that already. That doesn't change a thing.