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

Inconsistent formatting of section numbers 0
Currency autofit 5
Excel does not accept text format! 0
Excel currency format does not translate correctly in a Word merge 2
Format Cells - Currency v. Accounting 1
Mail Merge - displaying a conditional number of decimals 5
Excel - Wich Function should I use? 1
How to change font & size of (all) citation numbers? 7

Top