Righty,

Been tasked to tidy up a spreadsheet….

One of the columns has value, but folks have input using currency format.

I need to convert to GBP base.

Don’t suppose anyone knows of an excel function which I could then apply on another column which would clearly state the actual currency in my initial cell – e.g. =currency(A1)

That way I could simply build a lookup table with exchange rates and convert from base currency to GBP?

Can’t you just set the cell format to currency?

Have a look at the “=CELL()” function. Should be able to do what you want with that.

jon, cells are already set to currencies, but I need to convert into GBP to allow me to pull out those which are above a certain GBP threshold….