ExcelBanter - Spreadsheets: negative numbers in brackets

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

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

- - Spreadsheets: negative numbers in brackets (https://www.excelbanter.com/excel-discussion-misc-queries/159189-spreadsheets-negative-numbers-brackets.html)

Anslyst

Spreadsheets: negative numbers in brackets

How do I format Excel to always show negative numbers in brackets

Gary''s Student

Spreadsheets: negative numbers in brackets

Format Cells... Number Custom #,##0.00;(#,##0.00)
--
Gary''s Student - gsnu200746

"Anslyst" wrote:

How do I format Excel to always show negative numbers in brackets

helen

Spreadsheets: negative numbers in brackets

Gary,

Thank you, that was really, really helpful.

Helene

"Gary''s Student" wrote:

Format Cells... Number Custom #,##0.00;(#,##0.00)
--
Gary''s Student - gsnu200746

"Anslyst" wrote:

How do I format Excel to always show negative numbers in brackets

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