currency conversion

[vanja]

Hi,

Is there a posibility that i can convert values from one currency into another while replacing the original ones? I mean is there any formula or script that can manipualte on active cells? I have about 50 columns and dont want to make extra column for converted values.

Thanks, Vanja

p.s. one more thing, in some cells are not directly entered values but some math formulas/

 

[Mark W.]

To do such a conversion you'd have to know the exchange rate. How do you propose to supply such information?

 

[vanja]

I know the exchange rate. it's fixed rate, I don't need to do that regulary just from time to time i have to convert the values and it's really painfull to have extra 50 columns just for converted values.

 

[vanja]

another thought. I could define exchange rate as a NAME right? but the main problem is how can it calculate the values and store them in the same cell?
Isn't that a circular formula then ?

 

[Joe4]

Place your exchange rate in another cell (B1) for example. Then place your cursor in that cell (B1) and hit the copy button. Then, highlight the cells/columns you want to convert. From the Edit drop-down menu, select Paste Special. Then choose the Multiply (or Divide) option and click OK. This should convert the numbers.

 

[vanja]

Thanks!
It solved the problem. Great tip!