function to covert one foreign currency to another foreign currency?

[gbfell]

Does anyone know of a way to do this? we can convert an english currency to any foreign currency, but we need to be able to convert any foreign currency to any other foreign currency. example, icelandic to bulgarian.

 

[vb5prgrmr]

you can use simple math functions to accomplish what you are wanting to do.

i.e.

The japanese yen was at one time valued at 1.22 versus the american dollar.

So if you know the rate of icelandic versus the dollar and you know the bulgarian rate versus the dollar you should by know have the answer.

 

[vb5prgrmr]

you can use simple math functions to accomplish what you are wanting to do.

i.e.

The japanese yen was at one time valued at 1.22 versus the american dollar.

So if you know the rate of icelandic versus the dollar and you know the bulgarian rate versus the dollar you should by now have the answer.

 

[gbfell]

No, not mathmatically. i mean formatting with the currency symbol, decimal seperator, thousand seperator, etc...

 

[vb5prgrmr]

you should be able to find their symbols (currency markers) in the unicode character list. For formatting with 2 zeros and commas you could use...

variable = format(value, "#,#.00&quot

varialbe = format("12345.67","#,#.00&quot
variable = 12,345.67

variable = format("1234567","#,#.00&quot
variable = 1,234,567.00