I have set up web query to get data - no problem. I use the following formula to convert to number format:
=TRIM(SUBSTITUTE((SUBSTITUTE(A3," Million","000000"))," $ ",""))

Problem occurs when a3 = something like 1.5 million I want to convert to number format like above. Maybe a if statement? Any advice?

Thanks,
Jack