custom number format

[Trey Chandler]

I am looking for a custom number format: accounting, zeros to 0.00 rather
than the dash (-), and negative numbers in red. Does anyone have that custom
format written?

 

[JE McGimpsey]

One way:

_($* #,##0.00_);[Red]_($* (#,##0.00);_($* #,##0.00_);_(@_)