opening datagrid to Excel - Excel is changing the format of a column to a number from a string
I have a datagrid that has a column which is a string identity field that is 19 characters long - all the characters values are numeric. I'm exporting and opening the datagrid in Excel using a xslt file. Excel changes the values from string to numeric and the result is a number who's last character is incorrect and and displays in scientific notation.
Datagrid Column Value: 4003000000009010001
What I see in the resulting worksheet in Excel: 4.003E+18
What i see in the data field at the top: 4003000000009010000