Convert number with comma to number with dot

[Wessel Troost]

Hello,

Is there an easy way to convert "1.12" to a number, if your system is set
to use the comma as a decimal separator?

The value() function does not appear to take a format or locale as
argument.
The other way round is easy, with text() you can specify the format.

The problem occurs if you import an English web page into a Dutch
spreadsheet.

Greetings,
Wessel

 

[Bob Phillips]

Just select the cells and do a Find & Replace changing . to ,

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Wessel Troost]

Just select the cells and do a Find & Replace changing . to ,I'd have to do that every time the web query refreshes then.
I can write a VBA script to do it for me, but there has to be an easier
way?

Greetings,
Wessel