ExcelBanter - custom number format

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - custom number format (https://www.excelbanter.com/excel-discussion-misc-queries/136895-custom-number-format.html)

Trey Chandler

custom number format

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

custom number format

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?

All times are GMT +1. The time now is 01:32 PM.