Adding Formula to Existing Cells

[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?

 

[Chip Pearson]

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)

 

[PAIGE]

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)






.