You could use a double instead of string, but if you want to use strings and must remove the comma....
Just in case you were wondering about the double method
Code:
a1 = "123,456.78"
a1 = replace(a1,",","") 'replaces the comma with a blankJust in case you were wondering about the double method
Code:
a1 = cdbl("123,454.56")
