If the only currency conversion you ever want to do is from JPY to GBP, then

DataImport External DataNew Web Query
-Use this website:
http://finance.yahoo.com/currency/co...submit=Convert

-Select the table in that site with the conversion rate

Once you get the results in Excel, you can set up formulas that reference
the Fx rate.
Whenever you want to get the latest rate, right click on the results range
and select Refresh Data

Does that help?

***********
Regards,
Ron


"peterthistle" wrote:


With Excel 2003, is there a way to have a cell automatically update the
foreign exchange rate of yen to British pounds from the internet, and
then use that cell to do calculations?


--
peterthistle
------------------------------------------------------------------------
peterthistle's Profile: http://www.excelforum.com/member.php...o&userid=28921
View this thread: http://www.excelforum.com/showthread...hreadid=486641