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