Let you try add = "" & "<16-digit" in your csv file
For example: = "" & "0123456789123456789"

I am not sure that this will help you.

IrinaR เขียน:
I have *.csv file with 16-digit number(which is actually text ID), when I am
trying to open this file with Excel- it shows the 'scientific' notation for
this column, converting the column to text causes the rounding of the last
digit to 0 and then I am not able to use it as an ID.