View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Leo Heuser[_3_] Leo Heuser[_3_] is offline
external usenet poster
 
Posts: 109
Default decimal separator

Hi Tomek

Application.International(xlDecimalSeparator)

should work in all versions.

In Excel 2002 and forward, you can also use:

Application.DecimalSeparator

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Tomek" skrev i en meddelelse
...
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