Cell Formats

[ExcelBoy57]

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.

 

[Gord Dibben]

If negative brackets are not available in the Number>Negative Numbers
dialog.

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

Start>Settings>Control Panel>Regional and Language Settings>Regional
Options>Customize>Currency>Negative 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 OK>Apply your way out.


Gord Dibben Excel MVP