Hi,

I have a price list with varying amounts in columns. I'm want to add a conversion rate of 1.25 to the existing cells content.

IE: =5500*1.25
=7500*1.25

Etc, etc. Simple enough, except I have 20 pages of cells. Can anyone tell me if there is a way to add the formula (= ? *1.25)
to the existing cell content using an formula or key short cut. I've now put conversion rate in the document and changing
sum to =5000*G3 so I won't have to worry about this again but I am trying desperately to avoid having to change each and
every cell by hand. Quickest way I have so far is F2, paste and then arrow to put in the equals.

Had another document with 1.35 sum and tried find and replace but it replaces the entire cell content with 1.25.

Help would be GREATLY appreciated.

Many thanks

Rachel