convert 10 million to 10,000,000

[jackf-nc]

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

[pjwhitfield]

Please Login or Register  to view this content.

[jackf-nc]

Perfect.....! TY!