RE: Different language formats

Giganews Newsgroups
Subject: RE: Different language formats
Posted by:  mattgoof2005
Date: Wed, 14 Jun 2006

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?

Replies

None

In response to

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