How to compare 2 values equally

I have 2 string values 1,000.00 and 1000 i want both of them to matched
how can i achieve

Hi @T_Y_Raju,

You can convert both string expressions to double and compare them. The code below may be useful.

isMatch = (CDBL(str1) = CDBL(str2))

isMatch will be true, if the strings match.

You can do like this, or just put the expression to if’s condition block.


you can convert both values to Double with the following function:

CDbl(var1) = Cdbl (var2)

just take into consideration the following:

if your number, was “1.000,00” instead of “1,000.00”, you’d need to modify the string first, since the 1st value, would throw an error. Take that into consideration, in case you see the other format.


HI @T_Y_Raju

You can also try with CInt




Thank you Its working with your solution provided.

You are welcome @T_Y_Raju,

I’m glad it works, you can mark it as solution so that other people can benefit as well.