How do I make negative numbers automatically and always in parentheses as opposed to having a negative symbol? I have macaques and was wondering if there was a configuration for this? I know there is a number cycle to do this quickly, but wondering if I can make it the default for negative values to stated in () as opposed to " - #."Also is there a custom for this that can be set as default? This is for DCF, M&A, LBO stuff. Thank you.
| +313 | UBS Tech MD hires Son (from no-name college) as an Intern | 54 | 1h |
| +89 | [Official] 2026 IB Analyst Bonus Megathread (with 2025 Consolidated Pay and Perks/Benefits) | 12 | 1d |
| +52 | Is DCM actually underrated ? | 18 | 7h |
| +46 | Are all Tech / TMT groups sweaty? | 31 | 7h |
| +41 | UBS Groups Ranked by Future Outlook | 20 | 4d |
| +40 | JPM M&A is Gone??? Purely Coverage Banking??? | 20 | 7h |
| +37 | Am I behind? 31 Year Old Analyst | 10 | 10h |
| +32 | UVA McIntire vs Cornell Dyson for IB | 19 | 3d |
| +32 | Losing my personality in Banking | 5 | 22h |
| +31 | Incoming IB Analyst: Best Ways to Prepare? | 8 | 22h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
bum p
Format cells->Custom. #,##0;Red
This, except not that awful red
Just change format to accounting. Shortcut is also alt, h, n, accounting
Fuga aspernatur nihil et ut pariatur. Perspiciatis nesciunt mollitia placeat. Error maiores a dolores rem. Ipsum deserunt ut ipsa vitae. Quidem corporis ut suscipit consequuntur distinctio. Amet eveniet dolor id unde illo itaque nisi qui.
Dolor quidem commodi sit est earum. Necessitatibus enim tempora nostrum ipsa eos non. Pariatur enim quaerat quae.
Quae quis autem perferendis non. Facilis nemo quasi sed repudiandae fugiat. Itaque ut velit molestias similique. Optio aliquid rem recusandae laboriosam esse accusamus. Cum ea natus provident in. Fugiat sunt repudiandae temporibus a vel perferendis nihil ut. Earum sit hic dolor. Ea at rerum necessitatibus.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...