If 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.

Or go Bob's route and add his Format to your FormatStyleNormal

Gord Dibben Excel MVP

On Wed, 24 Nov 2004 09:29:06 -0500, "CarlosAntenna" wrote:

No need for a custom format.
Format Cells Number -- parens are an option in the dialog box.

Carlos

"David" wrote in message
...
Where can i find this formatting option?
TIA
--
David