Copying a multiplier from one cell to another

[christal]

I know this is easy, but for some reason I have drawn a blank... (Maybe I need coffee or someting)

I have in one cell 40 and I want to multipy this by 1000 so that the number reads 40,000. Problem is, I have to copy this formula to the rest of my spreadsheet! How do I do this without having to go in every cell and add the *1000???

Thanks for your help!!

[Audiojoe]

Howdy, just put 1000 in a cell somewhere, copy it, then PASTE SPECIAL>MULTIPLY onto the area you want to times it by

Audiojoe

[Ivan F Moala]

On 2002-05-14 04:56, christal wrote:
I know this is easy, but for some reason I have drawn a blank... (Maybe I need coffee or someting)

I have in one cell 40 and I want to multipy this by 1000 so that the number reads 40,000. Problem is, I have to copy this formula to the rest of my spreadsheet! How do I do this without having to go in every cell and add the *1000???

Thanks for your help!!

Hi Crystal...
1) In a seperate cell enter your
multiplier = 1000.
2) Copy this then select the range you want to multiply.
3) then goto Edit > Pastespecial > Multiply

[christal]

Thanks alot everyone....

Now I really feel like I need something more than coffee.... Maybe more sleep???

Your the greatest!