Thread: convert numbers with K and M
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bbs bbs is offline
external usenet poster
  
Posts: 2
Default convert numbers with K and M
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?
Reply With QuoteReply With Quote