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?

Tools-Options-International

"Anthony LeBaron" wrote:

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?

(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


"Anthony LeBaron" skrev i en meddelelse net.ca...
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?