Format Cell Number Options missing

N

Nadine

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
 
G

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
 
N

Nadine

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