Changing currency from European style to American

[TheJoneser]

I have a European version of Office that formats currency as 1.000,00. I
need to change it to the American convention of 1,000.00

Can someone please help me accomplish this. Thank you.

 

[Teethless mama]

=SUBSTITUTE(SUBSTITUTE(A1,".",""),",",".")+0

Format cells to your desired style

 

[Gord Dibben]

You could do this in Regional Settings in Control Panel or in newer versions of
Excel, 2003 for sure, you can set your decimal separators for Excel at
Tools>Options>International>Number settings.


Gord Dibben MS Excel MVP

 

[John Bundy]

That whole system across the pond is wierd go to Tools->Options->select
the International tab and you may have to uncheck 'use system seperators'
then change decimal seperator to . and thousands seperator to , *menu
options assuming they are named the same as mine!

 

[TheJoneser]

I don't have an International tab in the options dialog box. Maybe I don't
have an international version? I'm not sure now. At any rate it is Office
2000 if that helps.

 

[Gord Dibben]

You won't have one with 2000 version.

Was introduced with 2002 I believe.


Gord

 

[Peo Sjoblom]

That whole system across the pond is wierd go to Tools->Options->select
the International tab and you may have to uncheck 'use system seperators'
then change decimal seperator to . and thousands seperator to , *menu
options assuming they are named the same as mine!

Do you mean like the metric system as opposed to using the size of a foot of
a Roman soldier to measure distance

 

[Peo Sjoblom]

Assuming you are using Windows XP, do start>settings>control panel and
change the regional and language options, click customize and change decimal
symbol and whatever else is necessary

 

[James Silverton]

Peo wrote on Thu, 2 Aug 2007 12:24:34 -0700:


PS> ??>> That whole system across the pond is wierd go to
??>> Tools->Options->select the International tab and you may
??>> have to uncheck 'use system seperators' then change
??>> decimal seperator to . and thousands seperator to ,
??>> *menu options assuming they are named the same as mine!

PS> Do you mean like the metric system as opposed to using the
PS> size of a foot of a Roman soldier to measure distance

Nuts! It was the shoe size of Edward I of England. However, the
Romans confused everybody by defining a pace as two steps: Left
and right again. Hence mile comes from mille passi (1000 paces,
or something, I stopped Latin immediately after passing the
state exam, more long ago than I care to admit).

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

 

[Peo Sjoblom]

PS> Do you mean like the metric system as opposed to using the
PS> size of a foot of a Roman soldier to measure distance

Nuts! It was the shoe size of Edward I of England. However, the Romans
confused everybody by defining a pace as two steps: Left and right again.
Hence mile comes from mille passi (1000 paces, or something, I stopped
Latin immediately after passing the state exam, more long ago than I care
to admit).

I stand corrected. So it was the shoe size of a monarch of French
ancestry (Plantagenet)
I guess the French can claim the honour of both systems then? <bg>


Peo