software

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.

1. select the table
2. pull-down: Edit gt; Copy
3. select the destination range
4. pull-down Edit gt; 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 gt; Paste Special with the
multiply button checked.

--
Gary's Studentquot;Max-SRquot; wrote:

gt;
gt; I have a table in another currency that I want to convert to USD. Rather
gt; than converting each single cell I want to select the range of cells and get
gt; a new range of cells with the new values. Appreciate your help!
gt;
gt; Max.

Presumably you'll need to multiply the existing values by some
number to get the amount in the new currency. Enter in some blank
cell the value by which you are to multiply and copy that cell.
Then, select the table of numbers to change. Go to the Edit menu,
choose Paste Special, and choose the Multiply option.--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
quot;Max-SRquot; gt; wrote in message
...
gt;
gt; I have a table in another currency that I want to convert to
gt; USD. Rather
gt; than converting each single cell I want to select the range of
gt; cells and get
gt; a new range of cells with the new values. Appreciate your
gt; help!
gt;
gt; Max.

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.quot;Gary''s Studentquot; wrote:

gt; 1. select the table
gt; 2. pull-down: Edit gt; Copy
gt; 3. select the destination range
gt; 4. pull-down Edit gt; Paste
gt; 5. put the currency conversion factor in an un-used cell and copy this cell
gt; 6. select the destination range and pull-down Edit gt; Paste Special with the
gt; multiply button checked.
gt;
gt; --
gt; Gary's Student
gt;
gt;
gt; quot;Max-SRquot; wrote:
gt;
gt; gt;
gt; gt; I have a table in another currency that I want to convert to USD. Rather
gt; gt; than converting each single cell I want to select the range of cells and get
gt; gt; a new range of cells with the new values. Appreciate your help!
gt; gt;
gt; gt; Max.