Export to Excel - Numbers vs Txt

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:


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?

Unfortunately this issue cannot be fixed as it is the default behavior of Excel application. Not dhtmlxGrid but Excel converts numbers to that format.