Convert currency based on format of cell

[gunpowderboy]

I'm looking for a way of converting currency and I can't seem to find anything on the board (at least not that I understand how to implement...)

what I have:
Several times a week I get workbooks (all in different layouts) which contain both text and pricing.

What I need:
I need to be able to convert all cells which are formated as a specific currency (GBP, USD and EUR) into one of the orthr currencies.

What I think could be the solution;
A macro or something that performs like this (one fore ach currency) "IF A1:ZZ9999 is formated as currency (GBP) THEN add function =FOREX!C2* in same cell"

The reason fro the add fuction is that I need to be able to see the original numbers and update the exchage rate on a going basis.

Is this possible???

Thanks in advance

 

[GlennUK]

When you say that cells are formatted as a specific currency, do you mean that the cell number format has "GBP" or "USD" and is applying it to a real numeric entry, or do you mean that the cell is text entry containing "GBP" and a number?

If you mean that the original cells are formatted using cell number format, what cell number format would you want the cell to be after adding function =FOREX!C2* to it? Having the same currency number format afterwards would be inaccurate.