Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
find the screen shot
No difference for me whether right-click or upper right angle icon. What am I doing wrong? !
PS: I'm exporting from a straight table chart, if it makes any difference...
Hi Alexander
Try to convert your field to number and export as shown below.
num(yourfield,'#,###,###,#00')
Regards
ASHFAQ
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.
Hi
can you post some sample data
Regards
ASHFAQ
Hi
you can try by converting it to text
text(yourfield) as Field
Regards
ASHFAQ
Tried that already. That doesn't change a thing.