convert $ to £ or £ to $ function how?
how do i do this in a spreadsheet

You need to create an exchange rate somewhere, in a cell say, and
multiply/divide by this.

I suppose that you could add a webquery that pulls a value back
automatically, say when the workbook opens, and store that.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"emma storey" <emma wrote in message
...
convert $ to £ or £ to $ function how?
how do i do this in a spreadsheet