Description

The end-user is uploading an Excel file in the script.
They use commas (,) in Excel and SAP for the decimals separator in SAP
However, the comma (,) changes to the point (.) in the data file and gives an error that the format is not correct
The Excel cell format is Text
Their current location is Russia

Applies to

Transaction

Cause

The decimal symbol of the Windows system is point (.)

Solution

Or you change the Windows system settings
Go to Excel > Options > Advanced
Select 'Use system separators'
Go to control panel > clock, language and region > Region > Additional Settings... >
Change the decimal symbol from (.) point to (,) comma and leave digit grouping empty

Or you change Excel settings
Go to Excel > Options > Advanced
Unselect 'Use system separators'
in Decimal separator enter , (comma)