Hi Team,
When importing leads, if the lead field is defined as a text type, and the CSV file contains numeric values then CSV will convert the values in scientific notation format. As a result, the values will be stored in their scientific notation form in the system instead of being treated as plain text.
When you change the column format to ‘Number’ in a CSV file containing 15+ digit numbers and then close the CSV, upon reopening it, software will automatically convert those large digit numbers to scientific notation. This automatic conversion to scientific notation is done to handle the display of such large numbers and preserve their accuracy.
To ensure that the large digit numbers in the CSV file are imported correctly without being automatically converted to scientific notation, you can follow these steps:
1. Change the format of the column to “Number” in the CSV file.
2. Import the file without closing it immediately after changing the format.
By importing the file without closing it, you can retain the “Number” format you applied to the column, and the large digit numbers will be imported in their original format as intended, without being converted to scientific notation.
Regards,
Baibhav Kumar
