Impossible to have parenthesis for negative numbers (accounting) on Excel 2020 for mac

%3CLINGO-SUB%20id%3D%22lingo-sub-1853854%22%20slang%3D%22en-US%22%3EImpossible%20to%20have%20parenthesis%20for%20negative%20numbers%20(accounting)%20on%20Excel%202020%20for%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1853854%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EParenthesis%20for%20negative%20numbers%20are%20very%20common%20in%20Accounting%20-123%3D(123).%20I%20am%20stuck%20with%20the%20minus%20sign%20(-)%20and%20cannot%20change%20the%20format%20for%20parenthesis.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20go%20on%20%22more%20number%20formats%22%2C%20the%20option%20is%20not%20available%2C%20neither%20in%20Accounting%20or%20in%20Numbers.%20I%20can%20only%20turn%20negative%20numbers%20in%20red%20color.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20to%20mention%20my%20software%20and%20computer%20is%20in%20English%20but%20I%20live%20in%20Europe%2C%20maybe%20it%20has%20something%20to%20do%20with%20it%3F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThis%20is%20extremely%20annoying%20and%20prevents%20me%20to%20work%20with%20Excel%20for%20Accounting.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExcel%20version%20%3A%2016.42%3C%2FP%3E%3CP%3EOperating%20on%20%3A%20MacOS%20Catalina%2010.15.6%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1853854%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1854018%22%20slang%3D%22en-US%22%3ERe%3A%20Impossible%20to%20have%20parenthesis%20for%20negative%20numbers%20(accounting)%20on%20Excel%202020%20for%20mac%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1854018%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F857537%22%20target%3D%22_blank%22%3E%40HolySachet%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDoes%20Excel%20for%20Mac%20have%20Custom%20in%20the%20list%20of%20categories%3F%3C%2FP%3E%0A%3CP%3EIf%20so%2C%20select%20Custom%20and%20enter%20the%20following%20in%20the%20Type%20box%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%23%2C%23%230_)%3B(%23%2C%23%230)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eor%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E2%82%AC%23%2C%23%230.00_)%3B(%E2%82%AC%23%2C%23%230.00)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eor%20similar%20(if%20you%20use%20comma%20as%20decimal%20separator%2C%20switch%20point%20and%20comma%20in%20the%20formatting%20codes).%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0005.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F231477iD9627F1C55FA7490%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22S0005.png%22%20alt%3D%22S0005.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hello,

 

Parenthesis for negative numbers are very common in Accounting -123=(123). I am stuck with the minus sign (-) and cannot change the format for parenthesis.

 

When I go on "more number formats", the option is not available, neither in Accounting or in Numbers. I can only turn negative numbers in red color.

 

I have to mention my software and computer is in English but I live in Europe, maybe it has something to do with it?


This is extremely annoying and prevents me to work with Excel for Accounting.

 

Thanks

 

Excel version : 16.42

Operating on : MacOS Catalina 10.15.6

 

 

3 Replies

@HolySachet 

Does Excel for Mac have Custom in the list of categories?

If so, select Custom and enter the following in the Type box:

 

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

 

or

 

€#,##0.00_);(€#,##0.00)

 

or similar (if you use comma as decimal separator, switch point and comma in the formatting codes).

 

S0005.png

Whilst this works, the numbers is parenthesese (brakets) no longer align well with the number or accounting formatted cells above and below.... any suggestions welcome

@J_E-P 

It's best to use the same number format for all cells in a column. If you mix formats, anomalies are bound to happen...