Hi Jeffrey,

Just to confirm, but if you choose to Export Accounts from Adagio to a CSV file (with a separator of comma), then edit the created CSV file with notepad, the Dept code is correct. But if you open the same file with Excel, the depts above get converted to a different value? And you get similar errors if you Export the accounts directly to an Excel format?

If I export to a CSV file and open with Notepad, the contents are correct. When opening the CSV file with Excel 2007, or exporting directly to Excel, I saw the dept 21E082 get changed to 2.1E+83. That is because Excel interprets the value '21E082' as the scientific exponential format of a number 21 E 82, or 2.1 E 83.

This is an Excel issue, not Adagio. Try opening a blank Excel sheet and type 21E082 into a cell - it will get changed to 2.1E+83.

Unfortunately, your coding for some departments with a number followed by E followed by another number is not Excel-friendly. You need to avoid Excel and do everything strictly with CSV.