VBA question

PeCoNe · Jan 21, 2013

Cell A52 contains the text:

AEX*: 352,54 +1,65 +0,47% O: 351,84 H: 352,66 L: 351,84 C: 350,89

How can i substitute "," by "." in VBA

SUBSTITUTE(A52,",",".") does not work

Claus Busch · Jan 21, 2013

Hi,

Am Mon, 21 Jan 2013 14:40:42 +0100 schrieb PeCoNe:

Cell A52 contains the text:

AEX*: 352,54 +1,65 +0,47% O: 351,84 H: 352,66 L: 351,84 C: 350,89

How can i substitute "," by "." in VBA

SUBSTITUTE(A52,",",".") does not work

try Replace

Regards
Claus Busch