Skip to Content
Former Member
Aug 14, 2009 at 02:13 PM

export to excel - number format



Our version is SAP ERP Central Component 5.0 and we have just pathed the system from SPS18 to SPS23.

However from that time has change the export to excel functionality. Now after you select List - Export - Spreadsheet you can select either Excel (in Mhtml format) or All available formats - here the same format as in the old version has option 'Microsoft Excel (In existing XXL format). However when the report is exported eg account numbers do not have the correct format. So you need to convert them first to the correct number format with function VALUE in Excel.

Can this be somehow fixed?