Merry Christmas, I need to divide all cells in rows 2 and 3 by 100. Anybody know a way to do this?
B Brent E Dec 23, 2004 #1 Merry Christmas, I need to divide all cells in rows 2 and 3 by 100. Anybody know a way to do this?
P Peo Sjoblom Dec 23, 2004 #2 put 100 in a cell, copy it, select row 2 and 3, do edit>paste special and check divide Regards, Peo Sjoblom
put 100 in a cell, copy it, select row 2 and 3, do edit>paste special and check divide Regards, Peo Sjoblom
B Brandt Dec 23, 2004 #3 Put "=1/3" in a cell and then select it, copy, then select rows 2 and 3 and click edit | paste special | multiply.
Put "=1/3" in a cell and then select it, copy, then select rows 2 and 3 and click edit | paste special | multiply.
B Brandt Dec 23, 2004 #4 Oops, I meant put "=1/100" ... Brandt said: Put "=1/3" in a cell and then select it, copy, then select rows 2 and 3 and click edit | paste special | multiply. Click to expand...
Oops, I meant put "=1/100" ... Brandt said: Put "=1/3" in a cell and then select it, copy, then select rows 2 and 3 and click edit | paste special | multiply. Click to expand...
