Adding Formula to Existing Cells

  • Thread starter Thread starter paige
  • Start date Start date
P

paige

In Excel, I have a column with various numbers in each
row. I want to multiple each number by 1.02. Short of
doing this with extra columns, is there a way to use
find/replace and add *1.02 to whatever is already existing
in each cell?
 
Paige,

Enter 1.02 in some blank cell and copy that cell. Then select the number
you want to multiply by 1.02. Go to the Edit menu, choose Paste Special,
and choose the Multiply operation.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)
 
THANK YOU THANK YOU!!!!!
-----Original Message-----
Paige,

Enter 1.02 in some blank cell and copy that cell. Then select the number
you want to multiply by 1.02. Go to the Edit menu, choose Paste Special,
and choose the Multiply operation.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)






.
Click to expand...
 
Back
Top