Thank you for your reply. I tried your suggestion you gave to a different
user with the same problem but it didn't work. There seems to be something
different in Excel 2002 that's not letting the brackets show up.


"Gord Dibben" wrote:

Don't know what you have tried but this is the standard fix 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 Sat, 3 Dec 2005 17:43:01 -0800, "Ledeb"
wrote:

I have tried the suggestions from other users but the brackets do not appear.
This problem is only in Excel 2002 because I have Excel 2003 at work and the
brackets are there.