change range of cells to another currency
Thanks very much for your advice; it worked! I just could not find an
answer anywhere in Excel Help files! Fortunately there are human beings that
understand plain language and give an answer in plain language :-) Thanks
and Happy New Year for later!
Max.
"Gary''s Student" wrote:
1. select the table
2. pull-down: Edit Copy
3. select the destination range
4. pull-down Edit Paste
5. put the currency conversion factor in an un-used cell and copy this cell
6. select the destination range and pull-down Edit Paste Special with the
multiply button checked.
--
Gary's Student
"Max-SR" wrote:
I have a table in another currency that I want to convert to USD. Rather
than converting each single cell I want to select the range of cells and get
a new range of cells with the new values. Appreciate your help!
Max.
|