Forum Discussion

LeePace's avatar
LeePace
Copper Contributor
Feb 10, 2020

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 cells are what I need to reference as my primary keys in other applications.  However, when excel abbreviates them I always end up with entire columns of duplicates which is incorrect.  Could anyone offer some guidance on how to get around this issue or prevent excel from abbreviating them?

 

Thanks in advance! 

Need Help

1 Reply

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Feb 10, 2020
    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).

Resources