Summary:
This article explains how to correct a formatting issue in which Excel converts account strings into a date format.
Article Sections:
Symptoms:
When using account strings with the format: xxxx-rr-zz, Excel sometimes automatically formats it to look like: zz/rr/xxxx
The result is something similar to the picture below. This will cause issues if you are using Planning or Portal to save back transactions.
Causes:
If certain conditions of the numbers are met, Excel will auto-format to Date if the formatting style has not been hard coded to the column or cell(s).
Resolution:
In order to prevent Excel from auto-formatting these account string fields as dates, you will need to hard code the column or area to format TEXT (see below).
This will maintain the account string format when the report is run and prevent storage issues.
Properties:
Applies to:
Report Designer