I have a text field call [Account Number] that usually (but not always) contains only numeric values. If this contains greater than 15 characters, then characters 15 and onward are saved to excel as zeros. If the number starts with 0 (or 00, 000, etc) none of the leading zeros will be part of the excel spreadsheet.
Adding any kind of non-numeric character circumvents these issues, but then I have to remove that character once it's in excel. Is there a better way?