3673462 - Data in 'Manage Workforce' CSV import template is getting converted to scientific notations like 1.53202E+11

• Scientific conversion of values in ‘Worker and Work Agreement’ CSV import template.
• When values are copied and pasted into certain fields (e.g., Bank Account, Telephone) within the Worker and Work Agreement CSV import template, saving and then reopening the file causes the data to automatically convert into scientific notation.
• As a result, when these scientific notation values are later copied into SAP, incorrect or unintended data is transferred.

SAP S/4HANA Cloud Public Edition.

1. Open Manage Workforce application.
2. Download template from Import option 'Worker and Work Agreement'.
3. Copy values from customer files into the CSV columns in 'Worker' CSV template for fields like BankAccount, Telephone etc.
4. Save.

This conversion happens because Microsoft Excel automatically converts large numerical strings into scientific notation when saving the file in the CSV format. This is done to save space, but it converts the data into scientific notation for the SAP import.

To prevent this from happening, follow the below steps:

1. Format the required column in the CSV template as text (right click the column -> Select format cell’s -> Text).
2. Copy values from customer files into the CSV column. 
3. Save the file.
4. Import the file.

**Disclaimer: Follow the above steps each time you reopen the csv file. In future, importing of such scientific notations will be prevented by manage workforce validations.

Scientific notation, CSV Template, Worker, Work Agreement, Format Cell, Manage Workforce. , KBA , CA-GTF-BUM , Business User Management , Problem