I am facing problem in making code compatible with countries other than
united states

If locale is US :- The value of string variable assigned to Single
variable correctly

Dim my_num_st As String
Dim my_con_single As Single

my_num_st = "0.8"
my_con_single = CSng(my_num_st)

MsgBox (my_con_single) :- Display 0.8 (Correct)


If locale is Europe :- The value of string variable not assigned to
Single variable correctly

Dim my_num_st As String
Dim my_con_single As Single

my_num_st = "0.8"
my_con_single = CSng(my_num_st)

MsgBox (my_con_single) :- Display 8 (Incorrect)

Please help....


--
iamrajy
------------------------------------------------------------------------
iamrajy's Profile: http://www.excelforum.com/member.php...o&userid=28117
View this thread: http://www.excelforum.com/showthread...hreadid=476872

Dim my_num_st As String
Dim my_con_single As Single
Dim dec_sep as String
dec_sep = Application.International(xlDecimalSeparator)
my_num_st = "0.8"
my_num_st = replace(my_num_st,".",dec_sep)
my_con_single = CSng(my_num_st)

MsgBox (my_con_single)

--
Regrards,
Tom Ogilvy


"iamrajy" wrote in
message ...

I am facing problem in making code compatible with countries other than
united states

If locale is US :- The value of string variable assigned to Single
variable correctly

Dim my_num_st As String
Dim my_con_single As Single

my_num_st = "0.8"
my_con_single = CSng(my_num_st)

MsgBox (my_con_single) :- Display 0.8 (Correct)


If locale is Europe :- The value of string variable not assigned to
Single variable correctly

Dim my_num_st As String
Dim my_con_single As Single

my_num_st = "0.8"
my_con_single = CSng(my_num_st)

MsgBox (my_con_single) :- Display 8 (Incorrect)

Please help....


--
iamrajy
------------------------------------------------------------------------
iamrajy's Profile:
http://www.excelforum.com/member.php...o&userid=28117
View this thread: http://www.excelforum.com/showthread...hreadid=476872