decimal separator

T

Tomek

Hi,
does anyone know how to check with VBA what decimal separator is set in the
system. I'm using MS Office '97 and Win98 but it probably works the same way
in other versions too.
thanks in advance for the tip.
Tomek
 
L

Leo Heuser

Hi Tomek

Application.International(xlDecimalSeparator)

should work in all versions.

In Excel 2002 and forward, you can also use:

Application.DecimalSeparator
 
T

Tomek

Hi Leo,
that's it! Great! At the same time I've learned of many, many other
parameters I often wondered about. The Application.International collection
gives a huge amount of useful information. Stupid me I didn't find it
before... :)
thanks a lot.
Tomek
 
Top