Re: French numeric formats

From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 01/06/05 

Date: Thu, 6 Jan 2005 18:50:25 -0000

Anthony,

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

-- 
HTH
RP
(remove nothere from the email address if mailing direct)
"Anthony LeBaron @interbrand.ca>" <aXXXlebaron<nospam> wrote in message
news:hbeDd.87753$vO1.516849@nnrp1.uunet.ca...
> 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
>
>