Full ASX Excel Spreadsheet, page-59

  1. Mah1
    10 Posts.
    clock Created with Sketch.
    19/04/17
    22:23
    Post #: 24153285
    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
    Likes Created with Sketch. 2  Upvote
    Stroke 3 Created with Sketch. Comments Created with Sketch. Reply

  2. Top Stories

 
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.