Excel - how replace comma with point in import data

Asked By Gepetto

21-Nov-09 02:06 AM

I import some stocks prices from the web. They come in with a comma as
decimal limitator and I need them to appear with a point instead. how can I
convert it ?

21-Nov-09 02:21 AM

Set up your Windows Regional Options (in Control Panel) for the Format in
which you want to read your input data.
Format Cells/ Number for the way that you want to display the output.
--
David Biddulph

21-Nov-09 02:54 PM

There are a couple of ways:
=SUBSTITUTE(A1,",",".")

Select the text you want to change, hit Ctrl+F, click the Replace tab, in
the Find What box enter a , and in the Replace With box enter a . then click
Replace All.

HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.