Hi Gord
Is this different in XL2000 to XL2003?
On my copy of XL2003, I am set for -1.1 on my Regional settings, not (1.1)
and the format I posted gives me Red (£23.45) (I posted $ for the OP).

Regards

Roger Govier


Gord Dibben wrote:
Mike

If the brackets option is not available
underFormatCellNumber................

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.

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


Gord Dibben Excel MVP

On Tue, 22 Nov 2005 12:28:06 +0000, Roger Govier
wrote:


Hi Mike

Try
FormatCellsNumberCustom
$#,##0.00;[Red]($#,##0.00)

Regards

Roger Govier


Mike wrote:

Hi - I use Excel 2000 and wish to display negative number, accounting and
currency values in parentheses. However in the Format Cell function in Excel
there is no option to use parentheses. The only option is to use the -ve
symbol or to display the value in red. How do I display the value in
parentheses.