Convert number with comma to number with dot

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Wessel Troost - 18 Jul 2007 14:51 GMT

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

Reply to this Message

Bob Phillips - 18 Jul 2007 15:04 GMT

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

Signature

---
HTH

Bob

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

> Hello,
>
[quoted text clipped - 10 lines]
> Greetings,
> Wessel

Reply to this Message

Wessel Troost - 18 Jul 2007 17:08 GMT

> 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

Reply to this Message