Skip to Content

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

Format numbers when exported to Excel

Hi,

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

Tags:
Former Member
Former Member replied

With this function you can't do it .

Use OLE objects

http://help.sap.com/saphelp_nw04/helpdata/en/db/9987bcc3cf11d194ad00a0c94260a5/frameset.htm

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