Full ASX Excel Spreadsheet, page-61

@Mah1 Thanks... I used (1) Extra cloumn though in mine Yes R53 is the cell.

(1)Market Capital
162.29M
......................................
Stripped out M
=SUBSTITUTE(LEFT(R53,LEN(R53)-1),".",",")
......................................
Added
0,000
......................................
=CONCATENATE(AB53,AC53)
162,290,000
--------------------------------------
--------------------------------------
(2)Market Capital
162.29M
...................................
=MID(R53,1,LEN(R53)-1)*LOOKUP(RIGHT(R53,1),{"B",1000000000;"K",1000;"M",1000000})
162290000
...................................
COMMA STYLE (number format)
162,290,000

Sonic