 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / January 2008How do I change - to ()
How do I get it so that if I put a - sign it changes to ( ) around the numbers? With a Custom Format such as 0.00;(0.00) best wishes  SignatureBernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email > How do I get it so that if I put a - sign it changes to ( ) around the > numbers? On 31 Jan, 19:16, "Bernard Liengme" <blien...@stfx.TRUENORTH.ca> wrote: > With a Custom Format such as 0.00;(0.00) > best wishes [quoted text clipped - 5 lines] > > How do I get it so that if I put a - sign it changes to ( ) around the > > numbers? As Bernard said, you need a custom number format. To do this, highlight the cell (or cells) that you wish to format. Right click and choose Format Cells.. Under the 'Number' Tab, choose 'Custom' from the list, where you'll see a list of custom formats which have already been set up for you. In the box which appears under the label 'Type', enter what Bernard explained (ie type "0.00;(0.00)" into the box) and then click ok. This will set up the number format as you wish. Hope this helps, Matt Richardson http://teachr.blogspot.com You could change the format of the cell, but if you want the ()'s to show up for negative numbers in the format|cells|number tab, you'll have to change a windows setting. Windows start button|control panel regional and language options regional options tab click the customize button currency tab change the negative currency format to show ()'s. > How do I get it so that if I put a - sign it changes to ( ) around the numbers? SignatureDave Peterson If negative brackets are not available in the Number>Negative Numbers dialog. This is a function of your Regional Settings in Windows OS. Start>Settings>Control Panel>Regional and Language Settings>Regional Options>Customize>Currency>Negative Currency Format. Click on drop-down arrow and select the ($1.1) Note: this is under the "Currency" tab in Regional Options. Changing under the "Numbers" tab only does not do the trick. Apply and OK>Apply your way out. Gord Dibben Excel MVP >How do I get it so that if I put a - sign it changes to ( ) around the numbers? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.