VBA - decimal separator issue

[togo]

Hi, I have a data set in the html page looking as table containing numbers, dates, times, strings etc. each in separate column. I'm trying to copy this data set to excel and format it as I want with VBA. The only problem I have is that the source data set is using DOT "." as decimal separator and I want to use COMMA "," instead - according to my regional settings of Windows, excel is not considering DOT separated numbers as numbers.

I can do:

Selection.Replace What:=".", Replacement:=","

but after that, I'm getting errors for each cell - number formatted as text.decimal number.

How can I format it as number by VBA? When I replace DOT with COMMA by GUI Find and replace function it is formatted correctly as COMMA separated decimal number.

 

[togo]

The code I posted is not the same as the one you posted. Note that the replacement in my code is also a dot, not a comma.

Sorry, I didn't notice the difference, but actually this solved the problem, thanks.

 

[togo]

Solved