Decimal format in 2 languages
 

We work in English and French and would like to use the period in English and
the comma in French. If we make the change in Regional Settings, all the
applications and existing files are affected. How can we go from one to the
other without going through Regional Settings?

Thanks,

Decimal format in 2 languages
 

Hi Maureen

You could give the "appearance" of French values with a comma, by having
a column adjacent to your English data with
=SUBSTITUTE(A1,".",",")
and copied down
Format this column as Right justified.

Repeat for other columns as required.
Then have a simple macro which either Hides the English Columns, or
Hides the French columns

All calculations would have to be made on the English columns, as the
others would be just text representations.
--
Regards

Roger Govier


"Maureen" wrote in message
...
We work in English and French and would like to use the period in
English and
the comma in French. If we make the change in Regional Settings, all
the
applications and existing files are affected. How can we go from one
to the
other without going through Regional Settings?

Thanks,

Decimal format in 2 languages
 

You could try Edit Replace Find what: . Replace with: ,
or vise versa

"Maureen" wrote:

We work in English and French and would like to use the period in English and
the comma in French. If we make the change in Regional Settings, all the
applications and existing files are affected. How can we go from one to the
other without going through Regional Settings?

Thanks,

Decimal format in 2 languages
 

My mistake. In actual fact what we are looking for is an easy way to change
the space used for separating thousands in French with the comma used in
English (without changing the Regional parameters).

Do you a simple way of doing this?

Thanks,

Maureen

"Roger Govier" wrote:

Hi Maureen

You could give the "appearance" of French values with a comma, by having
a column adjacent to your English data with
=SUBSTITUTE(A1,".",",")
and copied down
Format this column as Right justified.

Repeat for other columns as required.
Then have a simple macro which either Hides the English Columns, or
Hides the French columns

All calculations would have to be made on the English columns, as the
others would be just text representations.
--
Regards

Roger Govier


"Maureen" wrote in message
...
We work in English and French and would like to use the period in
English and
the comma in French. If we make the change in Regional Settings, all
the
applications and existing files are affected. How can we go from one
to the
other without going through Regional Settings?

Thanks,

Decimal format in 2 languages
 

Hi Maureen

Then perhaps
=SUBSTITUE(A1," ",",")

--
Regards

Roger Govier


"Maureen" wrote in message
...
My mistake. In actual fact what we are looking for is an easy way to
change
the space used for separating thousands in French with the comma used
in
English (without changing the Regional parameters).

Do you a simple way of doing this?

Thanks,

Maureen

"Roger Govier" wrote:

Hi Maureen

You could give the "appearance" of French values with a comma, by
having
a column adjacent to your English data with
=SUBSTITUTE(A1,".",",")
and copied down
Format this column as Right justified.

Repeat for other columns as required.
Then have a simple macro which either Hides the English Columns, or
Hides the French columns

All calculations would have to be made on the English columns, as the
others would be just text representations.
--
Regards

Roger Govier


"Maureen" wrote in message
...
We work in English and French and would like to use the period in
English and
the comma in French. If we make the change in Regional Settings,
all
the
applications and existing files are affected. How can we go from
one
to the
other without going through Regional Settings?

Thanks,