Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    40

    Unanswered: billions,trillions..

    I have one row containing : 1,67 millions - 2,68 billions - 3,52 millions - 4,56 trillions - and many many other ...

    I have replaced milliona with a * 1000000 and after = 1,67 * 1000000 = 1670000.
    How can i drag the = to all the other cells so that automatically will make the (*) ????

  2. #2
    Join Date
    Feb 2004
    Posts
    533
    Quote Originally Posted by archVille
    How can i drag the = to all the other cells so that automatically will make the (*) ????
    Insert a column and write a formula to multiply just the number. You can drag the formula down the column to duplicate it for all your rows.

    This formula removes the text and commas from the number then mulitplies by 1000000.

    =SUBSTITUTE(LEFT(A2,SEARCH(" ",A2)-1),",","")*1000000
    ~

    Bill

  3. #3
    Join Date
    Nov 2005
    Posts
    40
    Quote Originally Posted by savbill
    Insert a column and write a formula to multiply just the number. You can drag the formula down the column to duplicate it for all your rows.

    This formula removes the text and commas from the number then mulitplies by 1000000.

    =SUBSTITUTE(LEFT(A2,SEARCH(" ",A2)-1),",","")*1000000
    i will try it and i see... thanx for the help!

Posting Permissions

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