ExcelBanter - Comma format

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Comma format (https://www.excelbanter.com/new-users-excel/139261-comma-format.html)

Raj

Comma format

How do I set the default comma format to show negative number as within
paranthesis. say -1234.567 as (1,234.57)

Can anyone help please ?

Gord Dibben

Comma format

FormatStyleNormalModifyCustom

#,##0.00_);[Red](#,##0.00)

Gord Dibben MS Excel MVP

On Tue, 17 Apr 2007 07:46:04 -0700, Raj wrote:

How do I set the default comma format to show negative number as within
paranthesis. say -1234.567 as (1,234.57)

Can anyone help please ?

All times are GMT +1. The time now is 03:12 AM.