Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
currency conversion | Excel Discussion (Misc queries) | |||
currency conversion | Excel Discussion (Misc queries) | |||
Quattro to Excel File Conversion | Excel Discussion (Misc queries) | |||
Conversion lookup formula | Excel Worksheet Functions | |||
Disable automatic date conversion feature | Excel Worksheet Functions |