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 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.