Can you apply exchange rate to a cell based on the currency it is formatted as?

Hi there,
Yes that is possible for most currencies. It will extract the currency such as $, but won't distinguish between different $ (US, Canada, Australia...)
You can use a UDF (User defined Function) to extract the currency symbol, then use that in a lookup table to get the exchange rate.

Copy/Paste the code below in a VBA module (you will need to save your workbook as macro enabled workbook).

In the spreadsheet use the UDF like other formulas in the cell you want the currency symbol extracted too: =GetCurr(A2) ..or wherever your currency amount is.

Please Login or Register  to view this content.