ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   how do I change the dollar sign? (https://www.excelbanter.com/new-users-excel/241824-how-do-i-change-dollar-sign.html)

JKing

how do I change the dollar sign?
 
HOW DO I CHANGE THE $ SIGN INTO RM?

Gord Dibben

how do I change the dollar sign?
 
FormatCellsNumberCurrency

Choose from the dropdown.

If you want it permanent for that workbook, change the currency style in
FormatStyleCurrencyModify.

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


On Sun, 6 Sep 2009 09:51:01 -0700, JKING
wrote:

HOW DO I CHANGE THE $ SIGN INTO RM?



Shane Devenshire[_2_]

how do I change the dollar sign?
 
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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"JKING" wrote:

HOW DO I CHANGE THE $ SIGN INTO RM?



All times are GMT +1. The time now is 03:44 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com