FAQ: AFS Formatting ZERO (0) values to display as DASHES (-) or vice versa

Question: I currently have zero values on the AFS for certain cells (left column) but I want to show then as dashes (right column). (Question: I want to change the value formatting of the numbers presented)

Answer:

When in the AFS, go to ‘format’ menu, for to ‘123 Number’ submenu. At the bottom, you can select ‘Custom number format’ from the drop down.

Once the ‘Custom number format’ s open, you can insert various syntax inputs next to the ‘apply’ button. A syntax line can be set for positive values, negative values, zero values, and 'text' values (error / warning display). Each of these are seperated with a semi-colon ;

• The first value before the ‘;’ is for positive values

• The second value is for negative values (e.g. negative sign is default. If you want to display negative as bracket, add brackets to front and back of second value)

• The third value is for zero values (e.g. if you want to display a zero, leave this blank. If you want to display a zeroed dash, insert the following inside the markings “-”

• Although not regularly used , the fourth is can assist to display notifications if the system sees it as text instead of a number. For this, the zero values must be set.

Please note that Zero value views (e.g. 0 instead of '-' dashes) are recommended on large structured tables (such as the appropriation statement) where all cells are published with the zero values in place (i.e. not hidden). This is to ensure line spacings as part of the Word conversion process through image recognition flow through.