converting comma to decimal point

[oli123]

Hello,

Would greatly appreciate some help with the following. I've just imported some external web data into Excel and I seem to be having a little problem. The decimal points (which should look like this 0.0) all appear as comas (0,0) with the result that Excel can't read them.

How do I permanently change the comas into decimal points so that they are readable?

THanks,
Oli
<hr style="color: rgb(235, 235, 235); background-color: rgb(235, 235, 235);" size="1">

 

[MrKowz]

Use the Find/Replace tool:

Find: ,
Replace: .

 

[oli123]

Use the Find/Replace tool:

Find: ,
Replace: .

Thanks very much! That was pretty simple...

 

[MrKowz]

Thanks very much! That was pretty simple...

Glad it worked for you. Thank you for the feedback.