Try the following:

=left(a1,len(a1)-1)*if(right(a1,1)="K",1000,if(right(a1,1)="M",1000 000,1))

--
Regards,
Fred


"bbs" wrote in message
...
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?