SOLVED

Excel cell format whole number accounting with negatives in brackets

Copper Contributor

When I had windows 10 I could put negative numbers in an excel cell into brackets quite easily using the accounting format provided.  Not so in windows 11, it appears I have to use custom settings.  I successfully arrived at a setting that allowed me to show (for example) negative ten pounds with no £ sign to show as (10.00).  I am having difficulty however with showing it as (10) i.e. as a whole number.

I have tried _(*###0_);_(*(#,##0);_(*"-"_);_(@_) but Microsoft tells me that it is not a permitted format, even though it appears to have worked on excel copies previously saved on windows 10.   I need to work in whole numbers and put negative numbers into brackets, so I would appreciate some assistance in finding the right formula.  In windows 1 you could do it through the regional setting in my PC Settings.

 

Thank you

4 Replies

@denis1944 

In Windows 11 that's also in Regional settings, you may select suitable for you format here

image.png

If you don't need currency symbol keep it as blank in Currency symbol

@denis1944 

Custom format could be like

image.png

depends on what exactly you'd like to have

best response confirmed by HansVogelaar (MVP)
Solution

@SergeiBaklan 

 

Thank you that worked perfectly.  Very nuch appreciated

1 best response

Accepted Solutions
best response confirmed by HansVogelaar (MVP)
Solution

@SergeiBaklan 

 

Thank you that worked perfectly.  Very nuch appreciated

View solution in original post