Big numeric values & Data Loader

Hi,

When using a data loader, it converts big numeric values to scientific notation.

for example:

in SF: the value Installs 121,212,121,212,222,278

in output CSV:

1.21212E+17

which mean I'm losing precision and the number in the CSV is rounded.

Is there a way to configure the data loader to do any conversion to large numbers?

Thanks.

Best Answer chosen by Admin (Salesforce Developers)

Jia Hu
Don't use Excel to open this .csv file.
Use Notepad or something else to open it, you will see the big number is exported with no problem.

Need an account? Sign Up

Have an account? Sign In