situation: a woman i work with pays thousands of invoices a year and records
them in a spreadsheet. When they are in different currencies, she doesn't
record the currency type as a value in a column, but merely formats the cell
as the currency type. I need to be able to eventually convert the amounts
into USD, but i guess i am looking for an interim step to create a column
that takes the formatting and converts to a currency code. I can see at
least 4 different currencies represented. Can anyone provide a formula that
can help me get to my end goal?
thanks!
N