Anthony,

Without changing the language settings, I was able to get it with a custom
format (FormatCells Format) of #,##0'(#,##0)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Anthony LeBaron @interbrand.ca" <aXXXlebaron<nospam wrote in message
...
I am having problems formatting french NEGATIVE numbers.
Specifically, our client requires negative numbers to be represented as (n
nnn), as opposed to -n nnn.
I have changed the language in my control panel, and Excel is accepting
the
space seperator, but is not accepting the brackets as an available option,
even though I have enabled this in the regional setting (customize)
Oddly enough, numbers in the thousands are properly displayed, but numbers
less than 1000 are displayed as -nnn

Any suggestions?

--
Anthony LeBaron
Senior Designer - Interactive
Interbrand
284 King Street East
Toronto, ON M5A 1K4

416 366 7100