Format Cell Number Options missing

[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

 

[David Biddulph]

Look in Custom formats.

 

[Nadine]

Not in custom formats

Look in Custom formats.

 

[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

 

[Nadine]

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

 

[Nadine]

Disre regard previous post. Was looking at it wrong.

Your fix worked. Thanks

 

[Gord Dibben]

Thanks for the feedback.


Gord

Disre regard previous post. Was looking at it wrong.

Your fix worked. Thanks