One way:

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

In article ,
"Trey Chandler" wrote:

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?