currency vs accounting

[lezawang]

Hi
I wanted to know the difference between currency and accounting number formatting. Excel easy website is saying this:

"Note: the Currency format can display negative numbers with a minus sign, in red, with parentheses, or in red with parentheses. The Accounting format displays negative numbers in parentheses."

I formatted 2 cells one as currency and one as accounting, when I entered -100, none of them changed the color to red or added ( )

Thanks you so much

https://www.excel-easy.com/examples/currency-vs-accounting.html

 

[Norie]

If you open the Format... dialog you'll see that there are several options on how to display negative numbers in the Currency category.

As for how the Accounting format displays negative values, perhaps that's dependent on locale.