Thanks for the feedback.


Gord

On Thu, 3 Apr 2008 10:19:00 -0700, Nadine
wrote:

Disre regard previous post. Was looking at it wrong.

Your fix worked. Thanks

"Nadine" wrote:

it brought back the brackets and the red formatting, but doesn't have the
minus in front of the numbers.

"Gord Dibben" wrote:

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 Wed, 2 Apr 2008 11:46:03 -0700, Nadine
wrote:

Format Cell Number Options

in the options for Negative numbers
only has the format for colour black and no brackets, doesn't have format
black with brackets
has no options for format colour red and or red with bracket
checked to see if it was document specific
opened a new blank workbook, and same in a new workbook
checked not using a start template