software

Joe

If negative brackets are not available in the Numbergt;Negative Numbers dialog.

This is a function of your Regional Settings in Windows OS.

Startgt;Settingsgt;Control Panelgt;Regional and Language Settingsgt;Regional
Optionsgt;Customizegt;Currencygt;Negative Currency Format. Click on drop-down arrow
and select the ($1.1)

Note: this is under the quot;Currencyquot; tab in Regional Options. Changing under
the quot;Numbersquot; tab only does not do the trick.

Apply and OKgt;Apply your way out.Gord Dibben Excel MVP

On Thu, 6 Apr 2006 16:40:01 -0700, Joe in Irvine, CA lt;Joe in Irvine,
gt; wrote:

gt;For some reason, when I try to format a cell with a negative number, the
gt;option to display it in parenthesis is nowhere to be found. It used to be
gt;located in Format, Cells, Numbers . . . I can not find that format in any of
gt;the standard number formatting options.
gt;
gt;I have not made any changes to my installation, etc.
gt;
gt;Any ideas?

Gord Dibben MS Excel MVP