Changing Dashes to ZerosLast updated on 08/23/18
Here’s how to change your dashes to zeros for monetary values.
Changing Dashes to Zeros
CIPC now requires that zero values reported in the printing section of the annual financial statements that will have XBRL tags on them are reported as zero (0).
To update your document:
Go to the table with dashes and select all monetary values.
Right-click and select Format Cells.
In the Values tab, click Advanced.
Uncheck Use dashes for zeros.
Verify that Symbol Placement in Advanced is set to decimals, not commas. Commas are not accepted by CIPC. If this needs to be changed, please reach out to your Customer Success Manager for assistance.