Thread: Difference between Currency and Accounting number format.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
  
Posts: 320
Default Difference between Currency and Accounting number format.
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);_(* "-"??_);_(@_)

"computerkiller" wrote:

What is the difference between Currency and Accounting number format in
Excel. (Recent release.)
Reply With QuoteReply With Quote