Format data

Format data in a report to improve readability.

For example, you can show all date values in the order year, month, and day. If you do not set Data Format properties here, data is formatted according to the properties set in the model. If the properties were not set in the model, data is formatted according to the International Components for Unicode (ICU) formats.

Special cells, such as overflow or underflow, errors, or not applicable values, appear with two dash (--) characters unless you override them.

You can also format data based on a condition or specify the format for a particular object.

When you create a calculation that uses mixed currency values or other mixed units of measure, an asterisk character (*) might appear as the unit of measure. To avoid this problem, change the format of the column or row that contains the result of the calculation so that the wanted unit of measure appears.