Peter,

You can change the currency symbol from the Format menu, Cells, then the
Number tab of that dialog. Choose "Currency" in the "Category" list, and
choose your desired symbol in the "Symbol" drop down.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)


"Peterwnixon" .(donotspam) wrote in message
...
Hi John,

Thanks for looking at this for me.

I am just trying to change the display symbol automatically throughout the
workbook i.e. "$10,000" to "£10,000" - so no changes in the actual
currency
value amount.
--
Kind regards,

Peter Nixon


"John Bundy" wrote:

Is this performing a calculation based upon exchange rates or are you
converting say Euros to dollars?
--
-John Northwest11
Please rate when your question is answered to help us and others know
what
is helpful.


"Peterwnixon" wrote:

Does anybody know of a why that I can get currency to automatically
update
throughout a work book. Ideally i would like to have the user select a
currency from a drop down list - and then this would then automatically
update all currency throughout the workbook.

Please help I would greatly appreciate it.
--
Kind regards,

Peter Nixon