Hi SB
Here is the formula I use to convert that column to a number, when I bring the raw data into other s/sheets ...
=MID(R3,1,LEN(R3)-1)*LOOKUP(RIGHT(R3,1),{"B",1000000000;"K",1000;"M",1000000})
... where "R3" is the cell with the Yahoo data in raw format (XX.XM)
Hope that helps
M
Expand
