Excel Formula for Millions and Billions

[rebel123]

Hello,

Thanks for your help.
I am looking to do a spreadsheet on stocks.
On Yahoo Finance, the data copies over as M and B for Billions.

Please check the attachment, and it shows these cells:
Columns C thru I
And Rows 360 thru 374

So, if you can please provide a formula for all of the green
highlighted cells in rows H and I want to copy and paste
that formula all of the way down.

Although you cannot see all of the way down, the numbers
appear like this (starting at cell G1363):

999.08M
996.78M
994.32M
994.09M
991.77M
990.90M
989.90M
987.90M
986.53M
98.35M
98.12B
98.03B
978.99M
972.92M
972.00M
969.83B
967.71M
964.30M
962.14M
96.44B
956.70M
956.42M
95.89B
946.91M
937.87M
931.18M
927.95M
92.79B
915.73M
915.04M
914.54M
913.43M
908.44M
907.96M
90.92B
90.80M
90.73B
9.96B
9.94B
9.94B
9.93B
9.83B

 

[rebel123]

IMAGE

 

[Fluff]

How about

+Fluff New.xlsm
	G	H
1
2	999.08M	999.08
3	996.78M	996.78
4	994.32M	994.32
5	994.09M	994.09
6	991.77M	991.77
7	990.90M	990.90
8	989.90M	989.90
9	987.90M	987.90
10	986.53M	986.53
11	98.35M	98.35
12	98.12B	98120.00
13	98.03B	98030.00
14	978.99M	978.99
15	972.92M	972.92
16	972.00M	972.00
17	969.83B	969830.00
18	967.71M	967.71
19	964.30M	964.30
20	962.14M	962.14
21	96.44B	96440.00
22	956.70M	956.70
23	956.42M	956.42
Admin

Cell Formulas
Range	Formula
H2:H23	H2	=LEFT(G2,LEN(G2)-1)*IF((RIGHT(G2)="B"),1000,1)

 

[gaz_chops]

Try

=IFERROR(SUBSTITUTE(SUBSTITUTE(G2,".",""),"M","0000")+0,SUBSTITUTE(SUBSTITUTE(G2,".",""),"B","0000000")+0)

 

[rebel123]

First one didnt work...
I may have moved my cells but its the same column

 

[rebel123]

2nd one didnt work.

 

[Fluff]

In what way didn't it work?

 

[rebel123]

Image

 

[rebel123]

1st one here

 

[Fluff]

You need to change the row number to reflect the first cell you put the formula in.