How can I crop a very large number?

[coolbeans12351]

Thank you so much for your reply! I figured out why I got such a strange number. I extracted it from a web table with multiple columns. The first column contained the cost $2,459.00; the second column contained a rate of 0.168

Any way I can extract only the number from the first column? Here's what I used to extract:

Code:

string1=Instr(1,prem1,"Minimum Premium",1)
string2=Mid(prem1,string1)
string3=Replace(string2,"Minimum"," ",1)
str_1=Instr(2,Trim(string3),"$",1)
CroppedPrem=Trim(Left(string3,str_1))

Again, I so appreciate your reply!