Formating Negative Figures in Brackets

  • Thread starter Thread starter Shrikant
  • Start date Start date
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 ?
 
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.
 
Back
Top