Excel Question
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.
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
At deleniti ab enim tenetur eum veniam vero. Expedita nobis et non at tempore nobis magnam. Voluptatum qui officia sit aut reprehenderit optio cupiditate optio. Odio quae modi eos quis.
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...