Skip to Content
0
Former Member
May 19, 2008 at 12:05 PM

excel download with right cell format

53 Views

i passed my internal table contains of all char type fileds to excel file in using function GUI_DOWNLOAD

or SAP_CONVERT_TO_XLS_FORMAT. but data show as below;

internal table excel sheet.

#1 1078137317 -> 1.08E+09

#2 2010000006001 -> 2.01E+12

#3 2008-06-15 -> ##########

how to show data correctly ?

#1, 3 were showed by double click, but #2, still show 2.01E+12.

Thanks in advance.

Benjamin.