Discover how to display accounting format as 0, not -. Essentially an answer to How to make accounting format show 0. Or how do I change my accounting number format? Some people have asked as how do I change the default accounting format in Excel?
Method 1 - Cell Format Currency
1) Select Paid Sum column
2) Ctrl + 1
3) Number tab
4) Currency
5) OK
Method 2 - Cell Format Custom
1) Select Paid Sum column
2) Ctrl + 1
3) Number tab
4) Custom
5) _-$* #,##0.00_-;-$* #,##0.00_-;_-$* 0.00_-;_-@_-
6) OK
Lets break it down what the custom cell format type mean.
_-$* #,##0.00_-;-$* #,##0.00_-;_-$* 0.00_-;_-@_-
_-$* #,##0.00-;
This section defines the format for positive numbers. It includes a currency symbol ($) and displays the number with a thousands separator (,) and two decimal places. If the number is positive, it will be displayed in this format.
-$* #,##0.00_-;
This section defines the format for negative numbers. It is similar to the positive number format but includes a minus sign (-) before the currency symbol to indicate a negative value.
_-$* 0.00-;
This section defines the format for zero (0) values. It displays a zero (0) with the currency symbol and two decimal places.
_-@_-
This section defines the format for text. It displays the text as it is without any additional formatting.
If you're just curious of what the original accounting cell format Custom type means, here is the explanation.
_-$* #,##0.00_-;-$* #,##0.00_-;_-$* "-"??_-;_-@_-
_-$* #,##0.00-;
This section defines the format for positive numbers. It includes a currency symbol ($) and displays the number with a thousands separator (,) and two decimal places. If the number is positive, it will be displayed in this format.
-$* #,##0.00_-;
This section defines the format for negative numbers. It is similar to the positive number format but includes a minus sign (-) before the currency symbol to indicate a negative value.
-$* "-"??-
This section represents the format for zero values.The _$ adds a currency symbol (e.g., $) at the beginning. The * allows space for an optional additional character. The "-" displays a hyphen (-) for zero values. The ?? displays two question marks for zero values.
