Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Format numbers when exported to Excel


I am a novice abap programer and i am facing the following problem.

I have a program that exports a table to a Excel worksheet.

I am using the functions call function 'WS_FILENAME_GET' and

call function 'MS_EXCEL_OLE_STANDARD_DAT'.

My question is that when i have a negative value in Excel i got for example 862.26-

Excel consider this like text so i need additional formats in Excel.

How can i solve this problem?

Best Regards

João Fernandes

Former Member
Former Member replied

With this function you can't do it .

Use OLE objects

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question