Difference between Currency and Accounting number format.

C

computerkiller

What is the difference between Currency and Accounting number format in
Excel. (Recent release.)
 
L

Loris

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

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);_(* "-"??_);_(@_)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format Cells - Currency v. Accounting 1
Excel 2007 cell format - numbers 2
Dollar sign alignment - Accounting vs Currency style 3
Numbers in a column won't add up 1
Excel Excel 2007 won't stop rounding down my formula results! 5
How do I get the parenthesis option in NUMBERS format, Excel 2007. 2
Excel - Replace blank cells 1
Refresh Data in Excel Spreadsheet 2

Top