Hi Jeffery,

To answer your original question - yes, something did change in the underlying method for importing or exporting records in Adagio Ledger 9.0C. Indeed when exporting accounts or other records using version 9.0B, a value of 21E083 did not get converted by Excel to 2.1E+84, but it does now when using Adagio Ledger 9.0C. Because of that, it is worthwhile for Softrak to see if there is anything in the formatting of string fields that can be modified to correct this when using Export.

Indeed Softrak is not solely to blame for the interpretation of the field value 21E083 into a Scientific format. This is because if you type this into a blank Excel spreadsheet, Excel changes the format - unless you type a leading apostrophe with the value, ie '21E083. This needs to be mentioned as part of the explanation of the problem.

If you use the Excel Direct button either directly from the Edit Accounts screen or from the SmartFinder using Adagio Ledger 9.0C, I can confirm that the department code does not get re-formatted to a scientific value but instead maintains the correct value.

I can also confirm that using Adagio GridView to create an inquiry on the Ledger account master file and exporting to Excel also maintains the correct value for departments. Perhaps using GridView to create (and even automate) the account exports can be of even greater value, because you wouldn't have to run each export manually.