Forum Discussion
Convert txt to excel
- Mar 22, 2018
Greetings, Damien!
I'm still not sure I believe this, but I tried using "General" alignment, with no indent, and all the decimals aligned perfectly. Go figure. You would think, though, that a leading spreadsheet program like Excel would have the option to align decimals!
Thanks for your input.
Jonni
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
- Gabriel Aguilar StassanoMar 22, 2018Copper ContributorThank you so much for your help. Now I understand why. I wasn't aware of the digit limit.