VBA question

[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

 

[Claus Busch]

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