Hi, I'm dealing with the decimal and thousands separator issue.

I'm taking a number through a WebQuery and its format is "," as
Thousands separator and "." for Decimal Separator. I tried to do the
checking to change the format of this number according to the user
separators, but when I type ?Application.DecimalSeparator in the
Inmediate window, I get ",", but if I type a number in Excel, it's using
the ".".
How do I understand this?
Which one would be the best way to format a number according to the user
separators if it come as "123,456,789.012"?

Regards,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.