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.