Thread
:
Currency Style Button
View Single Post
#
5
Posted to microsoft.public.excel.misc
Jon5001
external usenet poster
Posts: 8
Currency Style Button
Thanks Gary. This solves the problem for workbooks that have already been
opened. However, I still need to run through the commands below for every new
workbook that I create. Preferably, there'd be some setting that I could
change so that every new workbook would drop the euro for the $ symbol.
"Gary Brown" wrote:
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!
Reply With Quote
Jon5001
View Public Profile
Find all posts by Jon5001