ExcelBanter - Number format €“ accounting symbols

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Number format €“ accounting symbols (https://www.excelbanter.com/excel-discussion-misc-queries/204610-number-format-%E2%80%93-accounting-symbols.html)

Number format €“ accounting symbols

There a lots of entries for the $ sign in the accounting number format. They
all seem to display in the same way. What is the implication of picking e.g $
(English) Canada and $ (English) United States, or $ (English) New Zealand
and $ (Maori) New Zealand.
They must be there for a purpose, but what is it???

Number format – accounting symbols

No purpose that I have ever been able to ascertain.

Might have to do with language-specific versions of Excel but..........??

Gord Dibben MS Excel MVP

On Wed, 1 Oct 2008 03:39:01 -0700, Mary Ann
wrote:

There a lots of entries for the $ sign in the accounting number format. They
all seem to display in the same way. What is the implication of picking e.g $
(English) Canada and $ (English) United States, or $ (English) New Zealand
and $ (Maori) New Zealand.
They must be there for a purpose, but what is it???