Thread: how do I change the dollar sign?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default 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?

Reply With QuoteReply With Quote