MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Jo on January 04, 2002 8:01 AM

I asked this question before, but have lost everything on my computer because of a virus. Please tell me again how I can take a whole section of weights and quanitys and divide them all by 4.

Posted by Tom Urtis on January 04, 2002 8:05 AM

Type the number 4 in an empty cell, copy it, hilite your range of interest, Edit > Paste Special > Divide.

Tom Urtis

Posted by Ashmore on January 04, 2002 8:05 AM

You might try the same answer I received to my EURO question earlier this morning.