Euro Converstion

D

Del

I get this speadsheet once a month from one of my
retailers. There are usually 300 products with 300
different prices. Is there an easy way to convert all
this to US Dollars fron Euro in the spreadsheet?
 
R

Ron de Bruin

Please post in one group

1 Euro = 1.283 USD (Babylon 1/12/2004)

Enter 1.283 in a empty cell
Copy that cell

Select the 300 cells with prices
right click on it and choose Paste Special
Check Multyply
OK
 
Top