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? <br /><br />Method 1 - Cell Format Currency <br />1) Select Paid Sum column <br />2) Ctrl + 1 <br />3) Number tab <br />4) Currency <br />5) OK <br /><br />Method 2 - Cell Format Custom <br />1) Select Paid Sum column <br />2) Ctrl + 1 <br />3) Number tab <br />4) Custom <br />5) _-$* #,##0.00_-;-$* #,##0.00_-;_-$* 0.00_-;_-@_- <br />6) OK <br /><br />Lets break it down what the custom cell format type mean. <br />_-$* #,##0.00_-;-$* #,##0.00_-;_-$* 0.00_-;_-@_- <br /><br />_-$* #,##0.00-; <br />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. <br /><br />-$* #,##0.00_-; <br />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. <br /><br />_-$* 0.00-; <br />This section defines the format for zero (0) values. It displays a zero (0) with the currency symbol and two decimal places. <br /><br />_-@_- <br />This section defines the format for text. It displays the text as it is without any additional formatting. <br /><br />If you're just curious of what the original accounting cell format Custom type means, here is the explanation. <br />_-$* #,##0.00_-;-$* #,##0.00_-;_-$* "-"??_-;_-@_- <br /><br />_-$* #,##0.00-; <br />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. <br /><br />-$* #,##0.00_-; <br />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. <br /><br />-$* "-"??- <br />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. <br />
