View Single Post
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default Accounting format now no longer display negative figures in ( )'s

Use custom format and

_($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_)

--
Regards,

Peo Sjoblom

(No private emails please)


"R. Earl R." <R. Earl wrote in message
...
When selecting Accounting as the number format, negative figures used to
appear in brackets. That is now no longer the case. Negative figures
using
the Accounting format now appear with a minus in front. I have never used
any version of Excel other than Office XP.