Negative numbers in brackets
Keith
If negative brackets are not available in the NumberNegative Numbers dialog.
This is a function of your Regional Settings in Windows OS.
StartSettingsControl PanelRegional and Language SettingsRegional
OptionsCustomizeCurrencyNegative Currency Format. Click on drop-down arrow
and select the ($1.1)
Note: this is under the "Currency" tab in Regional Options. Changing under
the "Numbers" tab only does not do the trick.
Apply and OKApply your way out.
Gord Dibben Excel MVP
On Sun, 24 Sep 2006 08:21:01 -0700, Keith
wrote:
I cannot find an option for showing negative numbers in brackets when I go to
Format, cell, number. The only choices I find are either to show with minus
sign or in red. Any suggestions would be welcome.
Gord Dibben MS Excel MVP
|