how replace comma with point in import data

  • Thread starter Thread starter Gepetto
  • Start date Start date
G

Gepetto

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--
 
Back
Top