No need for a formula although it is probably better using one, for instance
you can
use a help column and put a formula like
=A2*rate
then just copy down
or you can put the conversion rate in a cell, copy it, select the range and
do editpaste special and select multiply
Regards,
Peo Sjoblom
"George_Papas" wrote:
How can I apply a formula to a range of cells without entering into each
cell. I have a spreadsheet with values and want to convert to another
currency value.
|