how do I divide or multiply an entire column?

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.

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


"1number" <1number@discussions.microsoft.com> wrote in message
news:9FAC98C2-A036-450C-9FCD-5096D34058A9@microsoft.com...
> 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.

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.

"CLR" wrote:

> 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
>
>
> "1number" <1number@discussions.microsoft.com> wrote in message
> news:9FAC98C2-A036-450C-9FCD-5096D34058A9@microsoft.com...
> > 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.
>
>
>

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.

1number wrote:
>
> 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.
>
> "CLR" wrote:
>
> > 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
> >
> >
> > "1number" <1number@discussions.microsoft.com> wrote in message
> > news:9FAC98C2-A036-450C-9FCD-5096D34058A9@microsoft.com...
> > > 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.
> >
> >
> >

--

Dave Peterson

And when Paste Specialling hit OK then Esc.


Gord Dibben Excel MVP

On Sat, 05 Mar 2005 11:55:11 -0600, Dave Peterson <ec35720@netscapeXSPAM.com>
wrote:

>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.
>
>1number wrote:
>>
>> 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.
>>
>> "CLR" wrote:
>>
>> > 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
>> >
>> >
>> > "1number" <1number@discussions.microsoft.com> wrote in message
>> > news:9FAC98C2-A036-450C-9FCD-5096D34058A9@microsoft.com...
>> > > 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.
>> >
>> >
>> >