Results 1 to 5 of 5

Thread: Format Cell To Convert Display Number As Billion / Million / Thousand

  1. #1
    Member
    Join Date
    Apr 2011
    Posts
    69
    Rep Power
    14

    Format Cell To Convert Display Number As Billion / Million / Thousand

    I have large data where i have numbers like 1.6 (million) i want convert them as 1,600,000 and so..

    i have attached the file for easy reference. if it can be done by formating cell it will be very good.

    kindly assist.
    Attached Files Attached Files
    Last edited by excel_learner; 10-16-2011 at 10:50 AM.
    ----
    excel_learner
    (Using XL 2007 & 2010)

    -------Learning never stops!

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Try this format

    0",000,000.00"

    Regards,

    Edit:Note: This only works if the number is a 1-3 digit whole number.
    EF
    Last edited by Excel Fox; 10-16-2011 at 02:24 PM. Reason: Note
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    Why do you want to just change the format? Why not the value itself? Like use =(B3+C3)*10^6 for million =(B3+C3)*10^9 for billion etc.
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  4. #4
    Member
    Join Date
    Apr 2011
    Posts
    69
    Rep Power
    14
    Thanks
    ----
    excel_learner
    (Using XL 2007 & 2010)

    -------Learning never stops!

  5. #5
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    13
    Quote Originally Posted by Excel Fox View Post
    Try this format

    0",000,000.00"

    Regards,

    Edit:Note: This only works if the number is a 1-3 digit whole number.
    As per you note, you can modify your Custom Format to handle numbers greater than 3 digits also by doing it this way...

    #,##0",000,000.00"

Similar Threads

  1. Convert a (Possibly) Very Large Positive Decimal Number to Any Base (Up To 36)
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 4
    Last Post: 04-22-2013, 04:52 PM
  2. Replies: 3
    Last Post: 04-05-2013, 08:24 AM
  3. Replies: 3
    Last Post: 03-31-2013, 06:18 AM
  4. Adding specfic number to a available number in previous cell.
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 2
    Last Post: 03-02-2013, 01:55 AM
  5. Convert Text In YYYYMMDD Format To Date Format
    By S M C in forum Excel and VBA Tips and Tricks
    Replies: 1
    Last Post: 02-28-2012, 12:04 AM

Posting Permissions

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