When we export for SQL servers and other sources, we frequently run into the
problem the text fields coming down with "E's" and numerics contained within
them (such as "26E13", which is one of our item numbers, not numeric - should
be text) comes down as "2.60E+13" under general setting in cell formatting.
If you try to convert to text, it will show "26000000000000".

Anybody suggest possible solutions?