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?