Different language formats

[Anthony LeBaron]

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?

 

[mattgoof2005]

Tools->Options->International

 

[Hans Knudsen]

(Excel XP)
Tools, Options, International, remove tick mark at "Use system operators".
Enter your Thousands separator and Decimal separator.
Settings will apply for the whole workbook.

Regards
Hans