cancel
Showing results for 
Search instead for 
Did you mean: 

export to excel - number format

Former Member
0 Kudos
5,109

Hi,

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?

Thanks,

Honza

Accepted Solutions (0)

Answers (6)

Answers (6)

0 Kudos

untitled.jpg

Hi,

After export in excel format, you should select all the numbers whom you want to convert into number format in single column wise. After selection you could see a dropdown box on the top right or top left of your selection. Click there and select "Convert to Number". It will convert all the number of that column in to number format.

Regards

Sanjay

Former Member
0 Kudos

Hello,

How did you solve the problem with the colon instead comma problem?

I have the same problem. I checked SAP user settings and regional OS settings and is OK.

Regards,

Pablo.

Former Member
0 Kudos

Hi,

If you get an answer please share. I use to use XXL relying a hundred percent on the data, however, I have two problems:

1) All numbers are exported changing the decimal character (.) to a colon (:).

2) All numbers below 10,000 are being divided by 24.

I do not like using the Export to file since at the end of the day I end up with tons of files and the layout is not always friendly.

Thank you in advance!

Former Member
0 Kudos

has not been solved

Former Member
0 Kudos

Hi Jan,

Can you please let me know if your problem has been resolved.. as i am also facing the same issue.

Thanks.

Former Member
0 Kudos

Hi,

Dots and commas is not the issue.

The issue is that eg doment numbers are in the format in which you cannot vlookup them with other files where document numbers are in number format. So you need first to convert them using excel function value(). And then they have the correct format.

I am 100% sure there was not the same problem before we installed the higher patch.

Jan

rene_coppens
Participant
0 Kudos

Hi

You do not really explain how the "format" is different but if it related to dot/comma issues, then you may want to check your user settings in SAP or the regional settings in Windows.

Rene