With the Currencies data kind you can easily get and compare exchange rates from about the world. In this article, you"ll learn how to enter money pairs, convert them right into a data type, and also extract much more information for robust data.
Use the Currencies data type to calculation exchange rates
Enter the money pair in a cell using this format: From currency / come Currency with the ISO currency codes.
You are watching: In this table, the reference currency is the
For example, enter "USD/EUR" to get the exchange price from one United claims Dollar to Euros.
Select the cells and then choose Insert > Table. Although creating a table isn"t required, it"ll do inserting data indigenous the data kind much easier later.
With the cells still selected, go to the Data tab and select the Currencies data type.If Excel finds a match between the currency pair and also our data provider, your message will convert to a data kind and you"ll see the Currencies icon
Note: If you watch
To extract much more information from the Currencies data type, choose one or much more converted cells and select the Insert Data switch
You"ll view a perform of all the fields easily accessible to choose from. Pick the fields to include a new column the data.
See more: Rizzoli And Isles Season 7 Dvd Release Date, News & Reviews
For example, Price represents the exchange rate for the currency pair, Last profession Time represents the time the exchange rate was quoted.
Stocks and also geography data types
just how to create formulas that recommendation data species
Thank you! Any an ext feedback? (The an ext you tell united state the more we deserve to help.) have the right to you aid us improve? (The much more you tell united state the much more we deserve to help.)