Assign: Conversion from string "Rs.82,900.04" to type 'Integer' is not valid

Some error found Assign: Conversion from string “Rs.703.3” to type ‘Integer’ is not valid.

You’ll need to remove the Rs. at the start, as it can’t convert currency codes to integer.

Assuming the string is a variable you could use:

var.remove(0,3)

And this would remove the first three characters (Rs.) and then you can convert that to integer. For more help see this forum link

CInt("Rs.82,900.04".Replace("Rs.", "").Replace(",", ""))

Cdbl retains the decimal places where as cint ignores it…

image

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.