Format Option Unavailable
 

Joe

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 Thu, 6 Apr 2006 16:40:01 -0700, Joe in Irvine, CA <Joe in Irvine,
wrote:

For some reason, when I try to format a cell with a negative number, the
option to display it in parenthesis is nowhere to be found. It used to be
located in Format, Cells, Numbers . . . I can not find that format in any of
the standard number formatting options.

I have not made any changes to my installation, etc.

Any ideas?

Gord Dibben MS Excel MVP