Hi,
I have some numbers in excel column. The numbers are like 1.9M (WHICH is 1.9 million) and 1.8K (WHICH is 1800) . How to convert these number as given below:
1.9M------>1900000
1.8K-------> 1800
Please help me about this problem.
Hi,
I have some numbers in excel column. The numbers are like 1.9M (WHICH is 1.9 million) and 1.8K (WHICH is 1800) . How to convert these number as given below:
1.9M------>1900000
1.8K-------> 1800
Please help me about this problem.
Hi, anonymous321!
Try:
=LEFT(A1,LEN(A1)-1)*10^IFERROR(VLOOKUP(RIGHT(A1),{"M",6;"K",3},2,),)
Blessings!
Or try this ...
=--SUBSTITUTE(SUBSTITUTE(A1,"M","E6"),"K","E3")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks