This link might give you some ideas:
http://www.bygsoftware.com/Excel/Int...conversion.htm

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"ReBecca" wrote in message
...
I have received several spreadsheets that all have the values as Euros, I
need to convert these values to GBP. The cells already contian formula.