Matts

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.

Gord Dibben Excel MVP


On Thu, 9 Dec 2004 09:33:05 -0800, "Matts"
wrote:

Hi,
When I trie to Format a cell, in Number Tab, Categorie Number, in the
negative Numbers:
I'm missing the 2 options of ( )
I on ly have 2 choices:
-1234.10
1234.10 (in red)
I need:
(1234.10)
(1234.10) (in red)
But its missing!
Anyone can help me?