put the currency conversion number in a cell outside the range of numbers you
want changed. Click on that number and then copy. Then click on the range
on numbers you want changed and click Edit/paste special and select the
multiply option and hit enter and all the numbers will be multiplied by the
conversion number.
Gary
"Nevi" wrote:
Hi,
I am trying to convert Canadian dollars into USD in the same cells where the
values are entered, i.e. I do not want to insert another column where I can
write a formula. How can i do that?
|