Ask Experts Questions for FREE Help !
Ask
    madie's Avatar
    madie Posts: 3, Reputation: 1
    New Member
     
    #1

    Dec 13, 2011, 08:16 AM
    Excel change number automatically?
    I have a column with numbers. I need to multiply the same numbers with 3 and I don't want to make a new column - it must happen in the same one. Is there any function for that?
    kcomissiong's Avatar
    kcomissiong Posts: 1,166, Reputation: 276
    Ultra Member
     
    #2

    Dec 13, 2011, 08:27 AM
    Can you give a little more info? Do you want to multiply all the numbers in the column or just some of them? You can write a formula for the cell you want the total to apper in. For instance, you can write a formula into a cell like =B8*B12 and that cell will equal the product of the new cell. Please let me know if this covers what you are trying to do.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #3

    Dec 13, 2011, 05:50 PM
    1) In an empty cell, put in your multiplier, in this case the number 3
    2) Now copy that cell
    3) Highlight all the numbers in your original column all at once
    4) Now select Edit > Paste Special > Multiply > OK
    madie's Avatar
    madie Posts: 3, Reputation: 1
    New Member
     
    #4

    Dec 14, 2011, 04:02 AM
    I need to multiply all the numbers in the column.
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #5

    Dec 14, 2011, 04:41 AM
    Quote Originally Posted by madie View Post
    I need to multiply all the numbers in the column.
    So did you try what JB suggested?
    madie's Avatar
    madie Posts: 3, Reputation: 1
    New Member
     
    #6

    Dec 14, 2011, 08:54 AM
    Sorry, I hadn't seen what JB had written. Now I tried it. THAT'S GREAT! I would never make it without you! Thanks a lot!

    Best wishes,
    M.
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #7

    Dec 16, 2011, 10:20 PM
    If you've never been in the Paste Special menu before, play around in there, that tool changed my "life" as far as Excel goes. Very powerful conversions at your disposal in there.

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

My folder name automatically change to .EXE [ 4 Answers ]

My folder name automatically change to .EXE

How do I change when emer heat automatically comes on instead of Hpump t8611g honeywe [ 4 Answers ]

My honeywell t8611g goes to emergency heat when I change temp up only two degrees. How do I change this so it will stay on heat pump when I change the temp up to three degrees?

Change Rs1208 to number in excel [ 1 Answers ]

Change Rs1208 to number in excel

If managers could automatically change each term in the equation of the cash conversi [ 1 Answers ]

If managers could automatically change each term in the equation of the cash conversion cycle, which of the following would be expected to provide the most benefit? A) Decrease numerator of each term by 10%. B) Decrease denominator of each term by 10%. C) Increase numerator of each term by...

Changing numbers automatically in excel [ 2 Answers ]

I have excel 2000 on my computer and downloaded a free invoice template. Over on the upper right it says invoice and then a blank for you to fill it in. I filled in a number and wanted to know if there is any way to have the invoice number change as I use the invoices without doing it manually?...


View more questions Search