![]() For this article, we set some limitations: Excel can grab that data and put it into cells for the worksheet. ![]() There are many places on the web which supply exchange rate information in a computer readable format. Tip: If you have Excel 365 there’s a much easier way see Exchange Rate support in Excel 365 Buy and get it today (just a few minutes from now) Real-Time Excel – get live stock, fund and bond prices, currency rates and more includes working spreadsheets for this tip and many other examples of getting live information into Excel. ![]() After all, Microsoft has been banging on about Internet integration for years and their main rival, Google, has an exchange rate function in their spreadsheets (see GoogleFinance() ). You might expect Excel to do this out of the box. ![]() No need to lookup a rate and type it in, let Excel do all that work for you. Here’s a ‘no fuss, no muss’ way to grab the latest exchange rates and use them in Excel. Thanks for joining us! You'll get a welcome message in a few moments.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |