Accounting number format in excel 2016
Accounting. Range("A1").NumberFormat = "_($* #,##_);_($* (#,##);_($* ""-""??_);_(@_)". This article is all about Currency format and Accounting format in Microsoft Excel. You'll get to know about the differences between them. If you select one of your cells formatted in Accounting and go Format --> Cells --> Number tab and then click on the Custom category.