| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
excel 2003 no brackets in number format
Excel 2003 does not display the option to format negative numbers in the
numbers format option. It shows two options both are with "-" |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
excel 2003 no brackets in number format
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. AndrewM wrote: Excel 2003 does not display the option to format negative numbers in the numbers format option. It shows two options both are with "-" -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
excel 2003 no brackets in number format
Already tried this route and has no effect on Excel.
In excel 200 under the format currency it showed up with 4 options, one set with brackets and one with minus symbol. Now all I see is the minus symbol. Andrew "Dave Peterson" wrote: 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. AndrewM wrote: Excel 2003 does not display the option to format negative numbers in the numbers format option. It shows two options both are with "-" -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
excel 2003 no brackets in number format
I'd try it again.
It works ok for me in WinXP and xl2003. AndrewM wrote: Already tried this route and has no effect on Excel. In excel 200 under the format currency it showed up with 4 options, one set with brackets and one with minus symbol. Now all I see is the minus symbol. Andrew "Dave Peterson" wrote: 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. AndrewM wrote: Excel 2003 does not display the option to format negative numbers in the numbers format option. It shows two options both are with "-" -- Dave Peterson -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
excel 2003 no brackets in number format
Dave
I had to change the format option under currency as well and then it worked. Thanks Andrew "Dave Peterson" wrote: I'd try it again. It works ok for me in WinXP and xl2003. AndrewM wrote: Already tried this route and has no effect on Excel. In excel 200 under the format currency it showed up with 4 options, one set with brackets and one with minus symbol. Now all I see is the minus symbol. Andrew "Dave Peterson" wrote: 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. AndrewM wrote: Excel 2003 does not display the option to format negative numbers in the numbers format option. It shows two options both are with "-" -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
excel 2003 no brackets in number format
Actually, you only had to change the format under the currency tab:
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 change the format on the Number tab back to what it was before. AndrewM wrote: Dave I had to change the format option under currency as well and then it worked. Thanks Andrew "Dave Peterson" wrote: I'd try it again. It works ok for me in WinXP and xl2003. AndrewM wrote: Already tried this route and has no effect on Excel. In excel 200 under the format currency it showed up with 4 options, one set with brackets and one with minus symbol. Now all I see is the minus symbol. Andrew "Dave Peterson" wrote: 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. AndrewM wrote: Excel 2003 does not display the option to format negative numbers in the numbers format option. It shows two options both are with "-" -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel negative number format options don't include brackets. Why? | Excel Discussion (Misc queries) | |||
| Label brackets switched around in 2003 | Charts and Charting in Excel | |||
| In excel 2003, the negative numbers not appearing with brackets | New Users to Excel | |||
| converted square brackets in worksheet name excel 2003 | Excel Discussion (Misc queries) | |||
| How do I show negative number in brackets using excel? | Excel Worksheet Functions | |||
Linear Mode
