How to show brackets around a negative number

A

Afsha

I have a negative number in a math calulation in Excel. I would like the cell
to automatically put brackets around this or to be able to format it this
way.... I have gone into Format/Cells/Number, but cannot find a way of doing
this here....

Any suggestions?
 
D

DILipandey

Hi Afsha,

Go to Format Cells - choose Number - >Under negative number section...choose
fourth one. Thanks.
--
Click on Yes, if it is useful.

Thanks & Best Regards,
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
 
D

Dave Peterson

If you want the ()'s to show up for negative numbers in the format|cells|number
tab, you'll have to change a windows setting.

Windows start button|control panel
regional and language options
regional options tab
click the customize button
currency tab
change the negative currency format to show ()'s.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Option to put brackets around negative numbers not available in 20 3
Negative Number Display -- need Brackets 7
Negative numbers in brackets 4
Displaying negatives with (brackets) 3
Formating Negative Figures in Brackets 2
Negative Numbers in Brackets 2
Spreadsheets: negative numbers in brackets 2
Excel not using regional settings 6

Top