Applying formula's to many cells

[Guest]

I am trying to multiply many cells by 1000, it will take years to type
"*1000" into every cell. Is there any quick method of applying this sum to
all cells?

Cheers
Luke

 

[JulieD]

Hi Luke

yes,
type 1000 into an unused cell somewhere and then copy it,
select the cells that you want to multiply by 1000 and then choose
edit / paste special, multiply

(please, test first on a backup of your data to see if this is what you're
really after)

Cheers
JulieD

 

[David McRitchie]

Text constants will be unaffected but if you want to restrict
to number constants and change empty cells to zeros you
might want to reduce the Selection to number constants
with Edit, Goto, Special, Constants, Numbers
if you also have formulas involved you will have to repeat for
Edit, Goto, Special, Formulas, numbers

 

[greg]

-----Original Message-----
I am trying to multiply many cells by 1000, it will take years to type
"*1000" into every cell. Is there any quick method of applying this sum to
all cells?

Cheers
Luke
.
Try using PRODUCT. then copy it to as many cells as you

need. ie. +Product(A3,B3) This will multiply what ever is
in A3 by what ever is in B3. Then copy the formula down as
far as you want using the PASTE SPECIAL command.

Hope this helps.
Greg