how replace comma with point in import data
 

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 ?

how replace comma with point in import data
 

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

"Gepetto" wrote in message
...
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 ?

how replace comma with point in import data
 

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''.


"David Biddulph" wrote:

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

"Gepetto" wrote in message
...
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 ?


.