View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max-SR
 
Posts: n/a
Default 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.