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.