Different language formats

Giganews Newsgroups
Subject: Different language formats
Posted by:  Anthony LeBaron (no@spam.org)
Date: Wed, 14 Jun 2006

I need to create excel spreadsheets using both english and french language
formats.
I believe I can accomplish different language formats by doing a global
change to my operating system, but I don't want to do this.

I have been able to change simple numbers by using custom masks i.e.
###,###,##0 becomes ### ### ##0

But I am unable to change the english decimal point to the french comma, as
the comma is automatically considered to be a thousands seperator.

##0,0 %;(##0,0) %  will not work. And there is no locale option for
percentage.

Any ideas?

Replies