asked on
Excel import of text file
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?![screen]()
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?
Microsoft ExcelMicrosoft OfficeSpreadsheets
Last Comment
John
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
@toooki - Thanks and I was happy to help.
.... Thinkpads_User
.... Thinkpads_User
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.