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.
>> >
>> >
>> >