Menu
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).
594
It's quite easy. First select all cells where formula results should be, then type the formula normally in the first cell, and then hit CTRL + ENTER .
To copy the actual value instead of the formula from the cell to another worksheet or workbook, you can convert the formula in its cell to its value by doing the following: Press F2 to edit the cell. Press F9, and then press ENTER.
If you wonder if a cell contains a formula, click the cell and look in the Formula Bar. Also, we can use AutoFill. Just click this little green handle in the cell and drag it down, and Excel automatically fills the formula to the other cells. It even updates the cell references to point to the right cells.
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.
111
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
