Excel apply formula to existing cells value without copy/paste

excel

Solution

Start by entering 1.43 in any empty cell in your worksheet (this is the Euro Value of one Lats currently).

Then copy that value:

Then select your range with Lats and Right click and select Paste Special:

On that menu Under operation select Multiply then click Ok:

and you should end up with the results:

You can delete the cell that has 1.43 in it when you are done.

Problem

I have an Excel file in which there is some data. This year Latvia entered into the Eurozone and Latvian Lats are replaced with Euro. So i need to convert all values from Lats to Euro without copying from one cell to another and then paste it back. All values are static (no formulas are used).

Original source