SAP Knowledge Base Article - Public

3378015 - Integration Center job exporting data in scientific notation (E numbers)

Symptom

An outbound Integration Center (IC) job is exporting files with CSV format. When opening the file in Excel, you are seeing numbers in Scientific Notation (E numbers).

Environment

SAP SuccessFactors HXM Core

Reproducing the Issue

  1. Run the IC job;

Cause

Excel tool is converting the numbers to Scientific Notation. If you open the CSV file in a text management tool (e.g. Notepad, Notepad++), you'll see there is no E numbers there.

Resolution

Excel is a third-party tool so SAP is not responsible for it, but these external blogs might help:

Keywords

convert, conversion, change, changing, modify, modifying, excel, csv, file, data, number, E, scientific, notation, enable, disable , KBA , LOD-SF-INT-INC , Integration Center , Problem

Product

SAP SuccessFactors HCM Core all versions