i'm using the FUNCTION 'MS_EXCEL_OLE_STANDARD_DAT' for export to excel.
how to make excel treat the numeric values as text values?
there is alignment problem for different numbers and text field values.
eg. numbers in excel are aligned to the right, text in excel aligned to the left.
i'm thinking of adding ' (apostrophe) to number...
but problem again..
eg. for the matnr field... it may contain fields like "00000123", "0023", "54".."abc".."abc00"...
how to get rid of the zeros?
Cheers,
Charles
abap newbie π