decimal separator

[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

 

[Leo Heuser]

Hi Tomek

Application.International(xlDecimalSeparator)

should work in all versions.

In Excel 2002 and forward, you can also use:

Application.DecimalSeparator

 

[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

 

[Leo Heuser]

You're welcome, Tomek, and thanks for
the feedback

LeoH

 

[Tomek]

Hi Leo,
that's what I needed. Thanks a lot!

 

[Leo Heuser]

You're welcome, Tomek, and thanks
for the feedback

LeoH