peter -
don't know if you're still monitoring this thread......
what about having option buttons on the spreadsheet (that don't print),
showing the available currency symbols? when the user clicks the
option button they want, the macro would automatically remove whatever
symbol/formatting which was there previously, and reformat it in the
new symbol.
just a thought............
or a floating modeless userform that would do the same thing.......
or one non-printing button that calls up a userform to do that.
susan



Peterwnixon (donotspam) wrote:
Thank you for the response - however, I did know how to change it. But is
there a way to pre-set up selected cells e.g. a budget colum on seperate
worksheets throughout a workbook - that would automatically change to the
desired currency. I.e. by setting up a drop down list I can populate the
entire workbook in one click with the correct currency symbol, rather than
individually changing 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.

Very appreciate your help with this.

--
Kind regards,

Peter Nixon


"Peterwnixon" wrote:

Dear Chip,

Thank you for the response - however, I did know how to change it. But is
there a way to pre-set up selected cells e.g. a budget colum on seperate
worksheets throughout a workbook - that would automatically change to the
desired currency. I.e. by setting up a drop down list I can populate the
entire workbook in one click with the correct currency symbol, rather than
individually changing 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.

Very appreciate your help with this.

--
Kind regards,

Peter Nixon


"Chip Pearson" wrote:

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