is there a quick way to multipy a large group of numbers by 1,000?
M Mary May 4, 2005 #2 Further explanation, I have different numbers in about 2500 cells. I want to multiply each number times 1,000 and have that product of the # in the cell times 1,000 present in the cell.
Further explanation, I have different numbers in about 2500 cells. I want to multiply each number times 1,000 and have that product of the # in the cell times 1,000 present in the cell.
D Dave Peterson May 4, 2005 #3 Put 1000 in an empty cell. copy that cell select your range of cells to adjust. Edit|paste special|check multiply Clean up that helper cell.
Put 1000 in an empty cell. copy that cell select your range of cells to adjust. Edit|paste special|check multiply Clean up that helper cell.
