Forum Discussion
Convert txt to excel
Hi Gabriel,
Excel has 15 digit limit in representing the numbers, your ID:s are 19 character long. The workaround not to convert such values to numbers but keep them as text.
Importing your file don't directly load it into Excel, select Transform data first
In opened query editor at right pane remove Changed Type step
result will be like this
After that close the editor with loading table to Excel sheet. Please see attached
Hi Gabriel,
It converted in another number, not format. 4551932613 is 4.5519E+9, not 4.5519E+18.
Could you please attach sample of your txt file with couple of records?
Hi Sergie, Thanks for the assitance. Here´s the original file .
Hi Gabriel,
Excel has 15 digit limit in representing the numbers, your ID:s are 19 character long. The workaround not to convert such values to numbers but keep them as text.
Importing your file don't directly load it into Excel, select Transform data first
In opened query editor at right pane remove Changed Type step
result will be like this
After that close the editor with loading table to Excel sheet. Please see attached
- Thank you so much for your help. Now I understand why. I wasn't aware of the digit limit.
