Microsoft Excel Limitations

 

Due to certain limitations, data in some cells may not appear as expected when the exported CSV file is viewed in Microsoft Excel:

• 15-Digit Limitation - you may notice that the values in certain report fields are preceded by a single quote character (‘) when opened as a Microsoft Excel file. Excel has a limitation whereby a column that contains a number greater than 15 digits in length is truncated. When the column is viewed as a number, Excel replaces the trailing digits with zeros, resulting in an invalid value.

  To address this, we have preceded each impacted column with a single quote in the exported report. This ensures that Excel interprets the information as text and displays the values accordingly. To remove all of the single quotations, simply apply the following formula to the affected columns:

  "=MID(B1, 2, LEN(B1))

• Leading Zeros Removed - you may also notice that certain columns may include a two or three-digit value. This occurs when the last four digits of the Account Number, the Account Suffix, contains leading zeros. For example, if the Account Suffix is ‘0021,’ the value is displayed as ‘21.’ Excel treats the Account Suffix as a numeric value and removes the leading zeros.