Formating Negative Figures in Brackets

S

Shrikant

Excel 2007
In earlier version of Excel, we could get a specific format for presenting
the negative numbers in brackets and / or in red color. I could not find it
in the Excel 2007. This can be done in the Custom Format. I do not have
specifics for it. Can you give me the format for the same ?
Why did the Excel remove this useful and oft needed feature from their new
version, or am I missing something ?
 
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

Spreadsheets: negative numbers in brackets 2
Negative Number Display -- need Brackets 7
Displaying negatives with (brackets) 3
show negative figures in brackets 3
Negative Numbers in Brackets 2
Negative figures in brackets 13
How to show brackets around a negative number 2
Option to put brackets around negative numbers not available in 20 3

Top