MegaSack DRAW - 6pm Christmas Eve - LIVE on our YouTube Channel
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....
