Results 1 to 5 of 5

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

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 10-16-2011, 10:46 AM #1
    excel_learner
    excel_learner is offline
    Member
    Join Date
    Apr 2011
    Posts
    69
    Rep Power
    15

    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!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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. Comparing Numbers When One Is Text Format And The Other Is Number Numeric Format
    By Howardc in forum Excel Help
    Replies: 3
    Last Post: 04-05-2013, 08:24 AM
  3. Convert a Number in Any Base (Up To 36) to a (Very Large) Positive Decimal Number
    By Rick Rothstein in forum Rick Rothstein's Corner
    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

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
  •  

Forum Rules