C computerkiller Feb 12, 2008 #1 What is the difference between Currency and Accounting number format in Excel. (Recent release.)
L Loris Feb 12, 2008 #2 Accounting format aligns all the dollar signs at the left edge of the cell, Currency aligns them next to the number. Accounting shows a dash for zero value, Currency shows a n actual zero.
Accounting format aligns all the dollar signs at the left edge of the cell, Currency aligns them next to the number. Accounting shows a dash for zero value, Currency shows a n actual zero.
B Bob Umlas, Excel MVP Feb 12, 2008 #3 Mainly in how zero shows. Currency: 0.00 Accounting: - the real difference is Currency has: #,##0.00_);(#,##0.00) Accounting has: _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)
Mainly in how zero shows. Currency: 0.00 Accounting: - the real difference is Currency has: #,##0.00_);(#,##0.00) Accounting has: _(* #,##0.00_);_(* (#,##0.00);_(* "-"??_);_(@_)
