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 ?

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 ?

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 ?


.