I have a table which often gets exported to excel via the export feature. I have a field in the table called "Utility_Account_Number__c" which is a Text field. in some cases a number can be up to 20 numbers. When exporting to excel, excel treats these fields as number fields instead of text fields. This causes the number to get all weird. Firstly the numbers show up in a scientific notation kind of look. Secondly even when telling excel to treat it as text, it is still messed up. For example a number that looked like 00532432402341233453 will come out like 5324324023000000000. Basically leading zeroes get thrown out, and later numbers get converted to zeroes. Obviously these numbers need to be accurate and this is causing quite an issue. I suppose this could be considered an excel issue, but I am setting the field as text in SFDC, so shouldn't it retain that data type during the export?