French numeric formats
From: Anthony LeBaron (nospam)
Date: 01/06/05
- Next message: Harald Staff: "Re: VBA Reference Book?"
- Previous message: JulieD: "Re: Sum function"
- Next in thread: Bob Phillips: "Re: French numeric formats"
- Reply: Bob Phillips: "Re: French numeric formats"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 6 Jan 2005 12:03:07 -0500
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
- Next message: Harald Staff: "Re: VBA Reference Book?"
- Previous message: JulieD: "Re: Sum function"
- Next in thread: Bob Phillips: "Re: French numeric formats"
- Reply: Bob Phillips: "Re: French numeric formats"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|