Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change - to ()
How do I get it so that if I put a - sign it changes to ( ) around the numbers?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change - to ()
With a Custom Format such as 0.00;(0.00)
best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Caron" wrote in message ... How do I get it so that if I put a - sign it changes to ( ) around the numbers? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change - to ()
Format Cell... Number (1234.10)
-- Gary''s Student - gsnu200766 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change - to ()
On 31 Jan, 19:16, "Bernard Liengme"
wrote: With a Custom Format such as 0.00;(0.00) best wishes -- Bernard V Liengme Microsoft Excel MVPwww.stfx.ca/people/bliengme remove caps from email "Caron" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change - to ()
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. Caron wrote: How do I get it so that if I put a - sign it changes to ( ) around the numbers? -- Dave Peterson |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change - to ()
If negative brackets are not available in the NumberNegative Numbers dialog.
This is a function of your Regional Settings in Windows OS. StartSettingsControl PanelRegional and Language SettingsRegional OptionsCustomizeCurrencyNegative 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 OKApply your way out. Gord Dibben Excel MVP On Thu, 31 Jan 2008 11:13:01 -0800, Caron wrote: How do I get it so that if I put a - sign it changes to ( ) around the numbers? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change scaling % but font size didnt change porportionally, pls he | Excel Discussion (Misc queries) | |||
Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
making copied cells change with change in original cell | Excel Worksheet Functions | |||
change info in other cells when i change a number in a drop list? | Excel Discussion (Misc queries) |