Office 365 Mac Excel 2011 numbers extracted from downloaded data sorts weird

[sdsaav]

Downloaded about 900 company stock market caps from Yahoo Finance the vast bulk of which is formatted like these examples:

9.923B

5.994B

28.416B

38.361B

4.181B

8.748B

92.671B

<tbody>
</tbody>

I've tried a half-dozen solutions around the internet that have worked for others but that I can't get to work for me so I can format the entries to sort. The last was this: =IFERROR(MID($A2,SMALL(IF(MMULT(ABS(ISNUMBER(0+MID(MID(" "&$A2,ROW(INDIRECT("1:"&LEN(" "&$A2)-7)),8),{1,2,3,4,5,6,7,8},1))-{1,0,0,0,0,0,0,1}),{1;1;1;1;1;1;1;1})=8,ROW(INDIRECT("1:"&LEN($A2)-7))),COLUMNS($A:A)),6),"") [XOR LX

Board Regular here]
which returned a blank cell. Others have returned #N/A or [zero].
When I try to sort my simpler solutions [eg., replace "B" with ""] I get a bunch of weird non-numerical & mixed mini-sorts like at least some entries are still read as text [no apostrophes] or something. Any suggestions? Thanks in advance! Shawn

 

[mole999]

If you want these as number only my thoughts (maybe not what you want)

B remove with substitute(A1,"B","") or similar

if its a text number then --A1 will convert to numeric (double minus)

not sureof the best way to construct the two together