I have a grid that lists information for an account, including the account number.
I have no control over the account number entry, so it could be alphanumeric, numeric, and even all numbers but starting with 0. These are some examples:
991AC553
77195342
00439951
556-000-3321
0080520000A00100
In the grid I have them set as datatype Link because clicking on the account number takes them to the page for the account detail.
When I export this grid to excel, the entries that include letters show up correctly, but the ones that are all numbers are formatted incorrectly - leading 0s are stripped off, and a number longer than 12 digits turns into scientific notation.
How can I fix this so they always show as text when exported?