Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - display negative numbers with minus sign and parenthe
Excel 2007 - display negative numbers with minus sign and parentheses
We go into format cells - select number - and there are only black or red choices with or without a minus sign. Don't have any of the choices with parentheses, In excel 2003 have choices with parentheses in format cells - number Is this feature gone in Excel 2007, search help and the help says - with or without paretheses, but when following instructions there are no options for parentheses are showing. OS is Vista Enterprise |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - display negative numbers with minus sign and parenthe
Could you try using a custom format, something like:
0.00_);-(0.00) Note that the part after semicolon is how you want to format negative numbers (in front of semicolon is how to format positive numbers) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Nadine" wrote: Excel 2007 - display negative numbers with minus sign and parentheses We go into format cells - select number - and there are only black or red choices with or without a minus sign. Don't have any of the choices with parentheses, In excel 2003 have choices with parentheses in format cells - number Is this feature gone in Excel 2007, search help and the help says - with or without paretheses, but when following instructions there are no options for parentheses are showing. OS is Vista Enterprise |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - display negative numbers with minus sign and parenthe
Answered it myself. Went into Regional and Language Options, Customize this
format. But first time I had just changed the negative value on the Numbers Tab But changed didn't show up in Excel Went back in and on the Currency Tab, changed the negative number format there as well. Reopened Excel now have the format options with parathesis. Guess needs to be set on both Numbers and Currency tabs for it to show in Excel properly. "Nadine" wrote: Excel 2007 - display negative numbers with minus sign and parentheses We go into format cells - select number - and there are only black or red choices with or without a minus sign. Don't have any of the choices with parentheses, In excel 2003 have choices with parentheses in format cells - number Is this feature gone in Excel 2007, search help and the help says - with or without paretheses, but when following instructions there are no options for parentheses are showing. OS is Vista Enterprise |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 - display negative numbers with minus sign and parenthe
Sounds like you are working with currency. You can change the options using
this procedure 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. You can always make a custom format. In my set up there is no foramt like ($123.24) with parentheses. Here are some sites I found with Google search using "Excel 2007 number format" http://www.microsoft.com/communities...&cr=&sloc=&p=1 http://www.msoffice-tutorial-trainin...ormatting.html http://books.google.ca/books?id=9f7K... ult&resnum=6 best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Nadine" wrote in message ... Excel 2007 - display negative numbers with minus sign and parentheses We go into format cells - select number - and there are only black or red choices with or without a minus sign. Don't have any of the choices with parentheses, In excel 2003 have choices with parentheses in format cells - number Is this feature gone in Excel 2007, search help and the help says - with or without paretheses, but when following instructions there are no options for parentheses are showing. OS is Vista Enterprise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I prefix a worksheet of numbers with a Minus (-) Sign | Excel Worksheet Functions | |||
Subtotaling minus negative numbers and posative numbers | Excel Worksheet Functions | |||
Removing beginning minus sign from telephone numbers | Excel Discussion (Misc queries) | |||
Formatting: Display a minus sign before a number | Excel Discussion (Misc queries) | |||
I want to display the minus sign | New Users to Excel |