convert $ to £ or £ to $ function how? how do i do this in a spreadsheet
E emma storey Feb 10, 2006 #1 convert $ to £ or £ to $ function how? how do i do this in a spreadsheet
B Bob Phillips Feb 10, 2006 #2 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)
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)
