Click on the pull-down list and choose ‘Update format’. This should happen automatically if the cell is empty or has the General cell format. Look at the sample table above, each ‘Rate’ has the correct currency symbol (Euro, Rupee etc.). Shortcut: Ctrl + Shift + F5 ( Cmd + Shift + F5 for Mac)Įxcel 365 has a nifty little trick up it’s sleeve which makes the rate currency symbol correct for each currency.Right-click on the data cell and choose ‘Show Card’.Clicking on the icon to the left of the main data cell.Exchange Rate CardĪ pop-up card shows all the details for that exchange rate pair. That seems to reduce the risk of a mixup with a similar stock/fund/bond codes (which can be more than three characters and can include a colon). It’s best to enter currency pairs with a slash separator like EUR /USD. HKD/CNY – Hong Kong Dollars to China Renminbi INR/SGD – Indian Rupee to Singapore Dollars The first currency is the one that buying the second currency.Īnother way express it: using ‘From Currency’ to buy the second named currency. Repeat step 5 for each field you want to display.Use the little field picker icon to select the field to add into the next empty cell to the right of the main data cell.The cell changes to show a little ‘stock’ icon at left.Wait for a few seconds while Excel gets the data from Microsoft’s servers.Go to Data | Data Types and click the Stock icon.We’ll use USD (US Dollar) and GBP (UK Sterling) – USD/GBP (best) USD:GBP or USDGBP
Live currency converter excel code#
All you’ll need is the currency code pairs (see below). If you’ve used the Stock or Geography data types, then this is exactly the same. USD/CAD USD:CAD and USDCAD will all work.
Type in a currency pair using the common three-letter currency codes, separated by either a colon : a slash / or nothing e.g. 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. As you’ll see, it’s a little fiddly but is better than what we had in the past (i.e. The currency symbol can be formatted correctly for each currency, in the above image see the UK Sterling, Euro, Russian Rouble prices among others. Here’s a selection to give you some idea of the range. About 160 currencies are supported by our count. They weren’t part of the original Stocks data feed but have been added very quietly.Įxcel 365 can show the latest exchange rates for a very wide range of currencies. No plugins or extras are necessary because it’s in Excel 365 though it’s hiding away.įoreign exchange rates are part of the Stock data type.
Live currency converter excel windows#
The latest global exchange rates can go directly into Excel 365 for Windows and Mac.