+ Reply to Thread
Results 1 to 4 of 4

Converting Numbers In Excel

  1. #1
    Registered User
    Join Date
    07-19-2017
    Location
    usa
    MS-Off Ver
    2007
    Posts
    21

    Converting Numbers In Excel

    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.

  2. #2
    Forum Contributor
    Join Date
    01-08-2015
    Location
    Cali, Colombia
    MS-Off Ver
    365 with 2016
    Posts
    176

    Re: Converting Numbers In Excel

    Hi, anonymous321!

    Try:
    =LEFT(A1,LEN(A1)-1)*10^IFERROR(VLOOKUP(RIGHT(A1),{"M",6;"K",3},2,),)

    Blessings!

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    2,944

    Re: Converting Numbers In Excel

    Or try this ...

    =--SUBSTITUTE(SUBSTITUTE(A1,"M","E6"),"K","E3")

  4. #4
    Forum Contributor
    Join Date
    01-08-2015
    Location
    Cali, Colombia
    MS-Off Ver
    365 with 2016
    Posts
    176

    Re: Converting Numbers In Excel

    Quote Originally Posted by Phuocam View Post
    Or try this ...

    =--SUBSTITUTE(SUBSTITUTE(A1,"M","E6"),"K","E3")
    Nice Phuocam! Blessings!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1