Australia's largest stock trading and investment forum Australia's #1 stock forum

Full ASX Excel Spreadsheet, page-60

First 60 Last

Share
Profile

Follow
WilliamWonka

28 Posts.

20/04/17

20:15

Post #: 24178521
Share

Originally posted by Mah1 ↑

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

Thanks for sharing.
Upvote

Reply

Top Stories

History-making uranium sample grades and an imminent drill run. Infini Resources is poised to transform in 2025

CHW

Cleo adds Royal Women's Hospital to its clinical trial for ovarian cancer diagnosis

WC8

Pan Asia rebranding to 'clear confusion' after bagging $35M for Chile projects

ACW

This biotech stock raised $11M in a risk-off environment. Its Alzheimer's drug could change the game

MIN

MinRes's Ellison knows he screwed up – for that reason, hunt for new Chair to be sped up

There are more pages in this discussion • 19 more messages in this thread...

First 60 Last