On the roster and change report files, why do some of the numbers appear as "#####" symbols or "1.02E+08"?

When using Microsoft Excel to open the roster or change report CSV files, columns are set at a default width. When number fields are wider than the width of a column, the number will display as #### or 1.02E+08. The solution is simply to widen the column to fit its contents. In Microsoft Excel 2003, you can widen all columns at once by selecting all data on the spreadsheet (click in the blank gray cell above the "1" and to the left of the "A"), then go to Format --> Column --> AutoFit Selection.