how replace comma with point in import data
in [Functions]
|
Prev: Can a customer name from pg1 of a workbook be the Header on all pg
Next: Vlookup, COUNTIF, IF or Nested
From: Gepetto on 21 Nov 2009 02:06 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 ?
From: "David Biddulph" groups [at] on 21 Nov 2009 02:21 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" <Gepetto(a)discussions.microsoft.com> wrote in message news:2D214513-6C9B-4E14-8AAD-EF7012728197(a)microsoft.com... >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 ?
From: ryguy7272 on 21 Nov 2009 14:54
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" <Gepetto(a)discussions.microsoft.com> wrote in message > news:2D214513-6C9B-4E14-8AAD-EF7012728197(a)microsoft.com... > >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 ? > > > . > |