ExcelBanter - negative number presentation

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

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

- - negative number presentation (https://www.excelbanter.com/excel-discussion-misc-queries/156590-negative-number-presentation.html)

sdprop

negative number presentation

how do I show negative numbers in parenthesis in Excel?

Mike H

negative number presentation

Try a custom format of

#,##0;(#,##0);0

Mike

"sdprop" wrote:

how do I show negative numbers in parenthesis in Excel?

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