Currency conversion
 

How do I set up cells in Excel to update different currency values against a
fixed currency ie British Pound

I then want to update them as I do for stocks and shares

I am using Office 2003 professional

Hi Brian

I do this by setting up a web query to www.xe.com from the tools -- get
external data menu and then use a vlookup to get the correct exchange rate.


"Brian Collier UK" wrote:

How do I set up cells in Excel to update different currency values against a
fixed currency ie British Pound

I then want to update them as I do for stocks and shares

I am using Office 2003 professional