When I open a text file (with separated fields) in Micrsoft Excel, it converts the number to something incorrect.
For example: The value 1189124350620307456 changes to 1.18912E+18. If I right click on the Excel field and 'Format Cell' and set the Category to 'Number' with Decimal places = 0,
it shows incorrect value 1189124350620300000.
So the original 1189124350620307456 changes to 1189124350620300000. Is there any way to fix this issue?
Also later someone said:
I tested it myself now, and a 32-digit string is converted into a number like 1.23457E+17 automatically.
The workaround then (proven to work in Excel XP):
- rename the file to .txt
- in Excel, use File>Open to open it, this will call the text import wizard
- after answering a few questions about format (delimited) and separator (,) you'll reach the screen where you can specify the format for each column. If you specify text for the column with these long numbers they won't be converted and still look like a 32-digit number.
It worked. Thank you.