HYPTUSS Dividend Tab - different currencies
Posted: November 18th, 2017, 8:45 am
Hi guys
As always so many thanks for all your work on HYPTUSS.
b-f.ods is all up and running well.
While I am in setting up mode....
On the dividends tab I use vlookup to give me a rough idea of the actual amount coming in for each share, but have been unable to cope with USD and EUR amounts. They just get treated as if they were GBP and come up with a spurious amount that I ignore.
Is there any (formula) way for me to separate out the currency info contained in column i so that I can make calculations on the fly?
The currency in each cell seems to be formatting element, rather than text, so I can't see a way to pull it out.
thanks
torata
As always so many thanks for all your work on HYPTUSS.
b-f.ods is all up and running well.
While I am in setting up mode....
On the dividends tab I use vlookup to give me a rough idea of the actual amount coming in for each share, but have been unable to cope with USD and EUR amounts. They just get treated as if they were GBP and come up with a spurious amount that I ignore.
Is there any (formula) way for me to separate out the currency info contained in column i so that I can make calculations on the fly?
The currency in each cell seems to be formatting element, rather than text, so I can't see a way to pull it out.
thanks
torata