Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default how do I change the dollar sign?

HOW DO I CHANGE THE $ SIGN INTO RM?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
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?


  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,346
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i change the dollar sign to sterling craigakconnolly Excel Discussion (Misc queries) 1 February 10th 09 09:47 PM
how can i change dollar sign to rupee sign in sales invoice vishal kohli Excel Discussion (Misc queries) 3 May 10th 07 02:06 PM
XL invoice replace the dollar sign with euro sign Pamela casares New Users to Excel 2 December 16th 05 08:21 PM
Dollar sign Ralphael1 New Users to Excel 6 October 7th 05 11:45 PM
i want to change dollar sign to rands on excel invoice? sylvia Excel Discussion (Misc queries) 4 July 19th 05 11:14 AM


All times are GMT +1. The time now is 07:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"