Excel currency conversion

H

Howard S

I wish to convert some of the vaues in my spreadsheet from £ to US$ and/or
Euros.

Help please.

Thanks

howard
 
T

Tom Ogilvy

put the multiplier in an empty cell

select the cell and do Edit=>copy

select the cells to be converted

do Edit=>Pastespecial, then select Values and Multiply
 
H

Howard S

Tom

Thanks for the message. Perhaps I need to clarify. I wish to covnert all the
calculated monetary values in my spreadhseet which covers 10 or more
worksheets into another currency. There are several thousand calcualtions.

Thanks and regards

Howard S
 
Top