Put one of the Regional Settings in a variable

[holysoul]

Hi,

i would like to know if it is possible to look into my Regiona
Settings and take one of the paramaters there (being the decima
symbol) and put it into a variable. Doing all this in my VBA code...

if it's possible please tell me how!

thanks for anyone trying

Holysou

 

[Chip Pearson]

You can get the internationals decimal setting with code like

Dim DecSep As String
DecSep = Application.International(xlDecimalSeparator)
Debug.Print DecSep


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[holysoul]

Thx Chip

that'S just what I needed!

Holysou