Euro Converstion
 

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?

Euro Converstion
 

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Del" wrote in message ...
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?