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.

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.

I think this is the correct usage :-

x=Excel.XlApplicationInternational.xlDecimalSepara to

--
Message posted from http://www.ExcelForum.com

BrianB < wrote:

I think this is the correct usage :-

x=Excel.XlApplicationInternational.xlDecimalSepara tor

Why is that?
From the inmediate window:

? Application.International(xlDecimalSeparator)
..
? Excel.XlApplicationInternational.xlDecimalSeparato r
3

Wouldn't a "." be easier to use (and read the code) than a 3?

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

The 3 is the value of the constant - it has no relationship to which
separator is being used.

--
Regards,
Tom Ogilvy


"Beto" wrote in message
...
BrianB < wrote:

I think this is the correct usage :-

x=Excel.XlApplicationInternational.xlDecimalSepara tor

Why is that?
From the inmediate window:

? Application.International(xlDecimalSeparator)
.
? Excel.XlApplicationInternational.xlDecimalSeparato r
3

Wouldn't a "." be easier to use (and read the code) than a 3?

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