Need Help Avoiding Conversion Error When Excel Abbreviates Values

[LeePace]

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! 

[#2]

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