Sheron

If bracketed negatives are not available in FormatCellsNumber.....

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)

Apply and OKApply your way out.

You will have to close Excel then re-open to see effects.

You will then be able to choose that format.


Gord Dibben Excel MVP

On Sat, 30 Apr 2005 06:08:02 -0700, "Pandorad"
wrote:

How do I get negative numbers in brackets if <Format<Cells<Numbers drop down
box does not show negative numbers in parenthesis. My spreadsheet shows
negative numbers with a '-' minus sign.

Thank you
Sheron