Re: Different language formats

Giganews Newsgroups
Subject: Re: Different language formats
Posted by:  Hans Knudsen (..@b.com)
Date: Wed, 14 Jun 2006

(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" <no@spam.org> skrev i en meddelelse news:9uVjg.26031$43.205…@nnrp.ca.mci.com!nnrp1.uunet.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?

Replies

None

In response to

Different language formats posted by Anthony LeBaron on Wed, 14 Jun 2006