Put one of the Regional Settings in a variable

H

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
 
C

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
 
Top