All cells in wksht to be multiplied by B3 (canadian conversion rate)

[Shelley]

I am trying to create a chart where every dollar amount
has to be converted into Canadian dollars, therefore,
every cell needs to be muliplied by the number in cell
B3. I would greatly appreciate some feedback, this is so
frustrating to me that I have not been able to figure
this out and I refuse to type the formula in each and
every cell manually

Desperately seeking answers.

 

[Frank Kabel]

hi
if this is a onetime operation try the following:
- select cell B3 and copy it
- select your target cells
- goto 'Edit - Paste Special' and choose the action 'Multiply'

 

[Guest]

Frank...I can't thank you enough! This works
beautifully, I knew it wasn't a complex function to
complete; trying to find the exact answer to my question
in the help text was brain damage! Thanks so much!!!

Shelley

 

[Frank Kabel]

Hi
thanks for the feedback

 

[Ken Wright]

If you don't want to lose the underlying values in your cells, then in any other
cell type =$B$3, then copy that cell, select all your data and do Edit / Paste
Special / Multiply. Each cell's value will now be =Value*($B$3) and so you will
ha the underlying values still, but the ability to change the rate at will
simply by amending B3.