currency converion

Hi, I had a question. I wanted to convert non-uniform data in single Excel column to uniform data into another column. Example- I have an Excel column containing values as 345.12 million, 128.56 billion, 2.67 trillion and I would like to convert this non-uniform data into a uniform way using VBA...

Excel allows us to retrieve currency quotes from Rifinitiv's database and populate a spreadsheet with the quotes. Using function XLOOKUP and some smartly laid-out tables, we can calculate all the cross-rates and their changes from the prior day's quotes. It's a simple process of refreshing the...

I would like to be able to toggle back and forth between 2 currencies - AUD & USD - with a conversion rate that our finance dep uses (example 0.72 right now) My spreadsheet (attached, dropbox link) is going to be full of Project costs for years, current actuals, monthly forecasts, summations...

Hi, is it possible to just open up my excel file and have US dollar and EURO currencies right there in front of me, up-to-date? (I'm asking for too much, right? :stickouttounge:)

Good Afternoon Excel Experts! I currently have a set of data that has two currencies: AUD and USD. In this set of data i have many columns of locations and columns of pricing - the service to be provided is quoted in both AUD and USD for different locations. I would like to make this pricing...

Hello, I have created a spreadsheet but what i am getting stuck on, is to work out how to do a real time cuurency conversion in four different rates. For example in the Dollars tab i enter 1,000 in cell b1 i would like excel to work out the real time currency in sterling in the sterling tab...