Topic starter
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?
Posted : 23/11/2011 6:00 pm
Can't you just set the cell format to currency?
Posted : 23/11/2011 6:06 pm
Have a look at the "=CELL()" function. Should be able to do what you want with that.
Posted : 23/11/2011 6:10 pm
Topic starter
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....
Posted : 23/11/2011 6:17 pm