Forum Discussion
LeePace
Feb 10, 2020Copper Contributor
Need Help Avoiding Conversion Error When Excel Abbreviates Values
Hey everybody, I need to import a data set from SQL into excel. The problem I'm encountering is that when I do this, excel always abbreviates the values in several columns. The values in these ...
JKPieterse
Feb 10, 2020Silver Contributor
Make sure you set up the import so that Excel recognizes the index column as text, I suspect Excel currently thinks it contains numbers and that your id's have more than 15 digits (Excel only allows 15 digits in a number).