K
Kim Luu
Currently I tried to save a workbook with field which has value say
376123456789012 into CSV format. Later on when I tried to load the CSV file
into Excel, the field is now displayed as 3.76E+14. The content of this
field is still correct i.e. 376123456789012. Without any modification to this
file I save it again into CSV format. Once file is saved, I loaded again into
Excel. This time the field value becomes 376123000000000.
Can you suggest a way to fix this problem.
Many thanks in advance.
376123456789012 into CSV format. Later on when I tried to load the CSV file
into Excel, the field is now displayed as 3.76E+14. The content of this
field is still correct i.e. 376123456789012. Without any modification to this
file I save it again into CSV format. Once file is saved, I loaded again into
Excel. This time the field value becomes 376123000000000.
Can you suggest a way to fix this problem.
Many thanks in advance.