FormatStyle
Select 'Currency' from the Style Name combobox
Select 'Modify'
Select '$' from the Symbol combobox
Select OK
Select OK

--
HTH,
Gary Brown

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"Jon5001" wrote:

Whenver I open a new workbook and use the currency style button, the cells
selected are formatted with a euro symbol instead of a dollar symbol.

I would like the cells to be formatted with the dollar symbol (this is the
default action I believe in new versions of excel). Is there any setting that
I can change so that the currency style button starts using dollar symbols
again?

I've checked my Regional and Language settings in the Control Panel in case
that was the problem. However, they are set to English (United States) and
United States.

Any help would be much appreciated. Thanks!