Converting $2B into a usable number in Google Sheets

[jasonkgreen]

I have a sheet with a column of valuations listed as $2B or $75M, etc. I used the following function to convert the valuation into what looks like a number, but I cannot use the results as a number. I can't get a sum of the converted valuations. Any suggestions on how to solve this problem?

=substitute(substitute(substitute(C2,"M","000000"),"B","000000000"),"$","")

 

[DanteAmor]

Just add + 0

=substitute(substitute(substitute(C2,"M","000000"),"B","000000000"),"$","") + 0

 

[jasonkgreen]

Perfect! Thank you