how do I change the dollar sign?

G

Gord Dibben

Format>Cells>Number>Currency

Choose from the dropdown.

If you want it permanent for that workbook, change the currency style in
Format>Style>Currency>Modify.

To have the change in all new Excel workbooks would require a change in your
Windows Regional and Language Options..


Gord Dibben MS Excel MVP
 
S

Shane Devenshire

In 2007 choose Home, click the quick launch button at the bottom right of the
Number group, pick Currency, and open the Symbol drop down.

It is considered bad etiquette to use all capitals in newsgroups - it shouting
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Switch - Dollars to Words 0
Office365 Outlook for work email change signature how ? 0
Microsoft 365 Activations, Users or Devices? 0
change from dollars to pound sign on balance sheets 1
Dropdown with signatures 1
apostrophe key produces "division sign" in Word 2008 for Mac 0
adding dollar signs 1
How DO I get the bold face toggle to show 1

Top