+ Reply to Thread
Results 1 to 4 of 4

Converting Numbers In Excel

  1. #1
    Forum Contributor
    Join Date
    07-19-2017
    Location
    usa
    MS-Off Ver
    2016 Professional Plus
    Posts
    128

    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
    Spammer
    Join Date
    01-08-2015
    Location
    Cali, Colombia
    MS-Off Ver
    365
    Posts
    302

    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
    2016
    Posts
    5,891

    Re: Converting Numbers In Excel

    Or try this ...

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

  4. #4
    Spammer
    Join Date
    01-08-2015
    Location
    Cali, Colombia
    MS-Off Ver
    365
    Posts
    302

    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)

Similar Threads

  1. How to stop excel converting numbers into time
    By PistachioPedro in forum Excel General
    Replies: 5
    Last Post: 02-29-2016, 01:20 PM
  2. excel 2002 converting tex to numbers etc
    By anon125 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-23-2015, 08:02 PM
  3. Stop Excel from converting numbers to Dateformat
    By ChrisNor in forum Excel General
    Replies: 13
    Last Post: 11-12-2011, 04:16 AM
  4. Excel converting decimals to whole numbers
    By koootzz in forum Excel General
    Replies: 6
    Last Post: 07-06-2010, 11:35 AM
  5. Excel is converting numbers to date ....arrgh!
    By tossan in forum Excel General
    Replies: 12
    Last Post: 01-12-2007, 08:03 PM
  6. [SOLVED] Excel: Auto converting text to numbers
    By Avi in forum Excel General
    Replies: 1
    Last Post: 10-19-2005, 05:05 PM
  7. converting copied data to numbers in excel xp
    By knutsenk in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 04-02-2005, 11:06 PM

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