Beto wrote:

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"?

On a side note, Application.International(xlDecimalSeparator) seems to
be returning the actual separator used in Excel. Any problems using this
command to recognize this? Is it available in all versions?

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