Skip to Content
0
Former Member
Nov 28, 2006 at 09:38 AM

Interactive list - export to excel

40 Views

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 😊