[diegogo]

Don't know that it has those kinds of formatting conditions. Probably your best bet is to do it the stupid way. So your A column would be amount, B column would be currency, C would be exchange rate to shekels, D would be amount in shekels, etc.

Added bonus is that this is database import-friendly and doesn't lend itself to inadvertently getting figures losing currency context due to formatting changes (happens surprisingly frequently in my line of work). Anybody gives you grief on doing it the stupid way, just say that you're planning ahead.

Good luck.

[Idorsearogele]

if you upload the excel I could probably solve it.

it is hard for me to think outside of excel context.

[ORDERCHEAPVIAGRASOFTWARE]

try the function "Cell"

info type is "format"

should return a code that differs for different currencies. Then you can take it from there.

and have a "zissen pesach."

[DagoIgnog]

cell(info_type, reference) will return format information, but it won't return which currency, sorry. AFAICT the function doesn't exist.

[ziIReIGS]

Originally posted by Kuciwalker
cell(info_type, reference) will return format information, but it won't return which currency, sorry. AFAICT the function doesn't exist.
I just tried it, using some cells formatted as currency dollars, and some as currency euros. It returns different values, because Excel thinks those are different formats.

[mr.memo]

Originally posted by Kuciwalker
It didn't for me, using USD and GBP. I actually used USD (with a dollar sign) and French (Belgian - dont ask me why) with a euro sign. I guess if you only have three character alpha, rather than a currency sign, Excel thinks its the same format.

Which seems odd.

[spacecrafty]

I noticed that too.