Difference between Currency and Accounting number format.

  • Thread starter Thread starter computerkiller
  • Start date Start date
C

computerkiller

What is the difference between Currency and Accounting number format in
Excel. (Recent release.)
 
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.
 
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

News Bank of England considers digital currency 4
Excel currency format does not translate correctly in a Word merge 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Currency autofit 5
Excel 2007 cell format - numbers 2
Format Cells - Currency v. Accounting 1
Stop XL from changing format? 1
Changing Default Accounting Formats 1

Back
Top