Cell Formats
 

I've been using excel for a while, then I got a new computer, installed
excel, then tried to do some formatting. Some formats are gone. I see
duplicates.

What I am trying to do is format negative numbers to be in brackets. I have
found a custom format that does this, but the format style I want used to be
under number. Now I just see the first two format types under number repeated.

Is there a way that I can fix this? Can I fix it without reinstalling excel,
or would that be the best fix?

Any help would be great.

Cell Formats
 

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, 6 May 2009 09:05:01 -0700, ExcelBoy57
wrote:

I've been using excel for a while, then I got a new computer, installed
excel, then tried to do some formatting. Some formats are gone. I see
duplicates.

What I am trying to do is format negative numbers to be in brackets. I have
found a custom format that does this, but the format style I want used to be
under number. Now I just see the first two format types under number repeated.

Is there a way that I can fix this? Can I fix it without reinstalling excel,
or would that be the best fix?

Any help would be great.