how can i show from web import data with dot decimal, as comma decimal

I am imorting data from web http://www.lme.com/aluminium.asp.
in my excel 2007 i am getting result with dot decimal as follows

ALUMINIUM Prompt Date Buyer ($)
Cash 07.09.2012 1,927.50

how can i show this result with coma as follows

ALUMINIUM Prompt Date Buyer ($)
Cash 07.09.2012 1.927,50

i have tried to chang option but i need this data to use in coma decimal excel, so it must be imported and converted in comma

thx

kaan

If your data is in A1:

=SUBSTITUTE(SUBSTITUTE(A1,",","."),".",",",4)

it does not work,

please see my attachment
thx
kaan
Book2.xlsx

at a1 dot must be show as coma, coma must be shown as dot in a2.xls

sorry wrong excell book2

see this one

Originally Posted by kaan

Attachment 178823

sorry wrong excell book2

see this one

thank you kevin,

i have solved the problem with your help. but correct formul is like that

=SUBSTITUTE(SUBSTITUTE(a1;".";",");",";".";1)