Jim,
As long as you don't have any negative numbers, it doesn't matter about
being 0 (0*n=0) or being text.
Try this
Put 1.2 in a spare cell and then copy it
Select all the cells
Goto menu EditPastespecial
Click the Multiply option
OK out
Now clear the cell with 1.l2 in
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Jim" wrote in message
...
How can I find all cells in a sheet that are a number
greater than zero and multiply each one by a number?
IE: the number to multiply by is 1.2
A1 Tom
A2 25
A3 0
G12 Bob
G13 25
I want to programatically (without using a macro) find
cells a2 and g13 only and multiply them by 1.2
Thanks in advance for your help.
Jim
|