hi,
the mid function might work.
for your first example....=MID(E8,1,5)*1000
for your second example....=MID(E9,1,7)*1000000
cells E8 and E9 in the formulas above would contain the values you wish to
convert.
read up on the mid function for more info.
yes i know. might be a little work but there isn't any consistency.

regards
FSt1

"bbs" wrote:

I have a column of text that represent numbers which have been abbreviated
with K (for thousands) and M (for millions). (e.g. 123400 is displayed as
123.4K, 123456000 is displayed as 123.456M) How can I convert these to
numbers?