how do I divide or multiply an entire column?

1

1number

I have a price list that I need to convert entire columns by either dividing
them or multipication. Is there a formula to do this.
 
C

CLR

Enter your multiplier in an unused cell, NOT in the column you're going to
multiply, then right-click on it and do Copy, then highlight the cells to be
multiplied and do .PasteSpecial, and check the Multiply box, then > OK

Vaya con Dios,
Chuck, CABGx3
 
1

1number

When I do the .Paste Special all I see is Text and Unicode Text. Also when I
try to highlight the cells it changes them all to the same number.
 
D

Dave Peterson

How did you copy that cell?

Did you copy the contents from the formula bar or did you select the cell then
Edit|copy?

If you didn't use Edit|Copy (or rightclick copy or ctrl-c), then try it that
way.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to remove a bracket that is itallicised for an entire document 1
Combining three files when middle file has sections with endnotes 2
VBA multiple list of values for variable 1
Excel does not accept text format! 0
Word VBA - Automatic change content of a cell in table using dropdown list 5
Two columns : Continuous two columns vs Parallel two Column 1
How do I enter Revenue. 0
Calculation of weighed average 6

Top