| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Negative Number Display -- need Brackets
I would like my negative numbers in Excel to display in brackets. This is
what the "accounting" category under "format cells" allowed us to do in the 2003 version. I cannot find a way to do this under any of the category options in "format cells". It is driving me nuts, please help if anyone knows! If there is no such option, please update excel 2007 to include this. It is very important to have this function for us accountants! -- Rinke |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Negative Number Display -- need Brackets
Go to Format Cells, Choose Custom option and enter #,##0_);[Red]\[#,##0\]
This will show negative numbers in RED and within []. Delete [RED] if you don't want that. To display [ you have to add it as \[... "Rinke Gill" wrote: I would like my negative numbers in Excel to display in brackets. This is what the "accounting" category under "format cells" allowed us to do in the 2003 version. I cannot find a way to do this under any of the category options in "format cells". It is driving me nuts, please help if anyone knows! If there is no such option, please update excel 2007 to include this. It is very important to have this function for us accountants! -- Rinke |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Negative Number Display -- need Brackets
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. Rinke Gill wrote: I would like my negative numbers in Excel to display in brackets. This is what the "accounting" category under "format cells" allowed us to do in the 2003 version. I cannot find a way to do this under any of the category options in "format cells". It is driving me nuts, please help if anyone knows! If there is no such option, please update excel 2007 to include this. It is very important to have this function for us accountants! -- Rinke -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Negative Number Display -- need Brackets
Out on a limb here but IIRC in the 2003 version if you installed XL using
Canada as your location you did not get brackets. I guess they thought us Canadian accountants didn't use Brackets. The US version has brackets so the standard fix was to change your location to US... Not sure if that applies to you or if it has been changed in 2007... -- HTH... Jim Thomlinson "Rinke Gill" wrote: I would like my negative numbers in Excel to display in brackets. This is what the "accounting" category under "format cells" allowed us to do in the 2003 version. I cannot find a way to do this under any of the category options in "format cells". It is driving me nuts, please help if anyone knows! If there is no such option, please update excel 2007 to include this. It is very important to have this function for us accountants! -- Rinke |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Negative Number Display -- need Brackets
Either use the shortcut Ctrl + 1 (not 1 on the numpad) and select
accounting, or click the general drop down on the home tab and select accounting, or right click the cell(s) and select format cells and select accounting or use a custom format _($* #,##0.00_);_($* (#,##0.00);_($* "-"??_);_(@_) I personally dislike 2007 but formatting is certainly not changed or hidden -- Regards, Peo Sjoblom "Rinke Gill" wrote in message ... I would like my negative numbers in Excel to display in brackets. This is what the "accounting" category under "format cells" allowed us to do in the 2003 version. I cannot find a way to do this under any of the category options in "format cells". It is driving me nuts, please help if anyone knows! If there is no such option, please update excel 2007 to include this. It is very important to have this function for us accountants! -- Rinke |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Negative Number Display -- need Brackets
Good catch, I forgot about that
-- Regards, Peo Sjoblom "Dave Peterson" wrote in message ... 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. Rinke Gill wrote: I would like my negative numbers in Excel to display in brackets. This is what the "accounting" category under "format cells" allowed us to do in the 2003 version. I cannot find a way to do this under any of the category options in "format cells". It is driving me nuts, please help if anyone knows! If there is no such option, please update excel 2007 to include this. It is very important to have this function for us accountants! -- Rinke -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Negative Number Display -- need Brackets
General interest... Is that a global change which changes all of the default
number formats or does it only affect the accounting format... -- HTH... Jim Thomlinson "Dave Peterson" wrote: 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. Rinke Gill wrote: I would like my negative numbers in Excel to display in brackets. This is what the "accounting" category under "format cells" allowed us to do in the 2003 version. I cannot find a way to do this under any of the category options in "format cells". It is driving me nuts, please help if anyone knows! If there is no such option, please update excel 2007 to include this. It is very important to have this function for us accountants! -- Rinke -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Negative Number Display -- need Brackets
It affects currency, too.
I've never seen it affect any custom number format. Jim Thomlinson wrote: General interest... Is that a global change which changes all of the default number formats or does it only affect the accounting format... -- HTH... Jim Thomlinson "Dave Peterson" wrote: 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. Rinke Gill wrote: I would like my negative numbers in Excel to display in brackets. This is what the "accounting" category under "format cells" allowed us to do in the 2003 version. I cannot find a way to do this under any of the category options in "format cells". It is driving me nuts, please help if anyone knows! If there is no such option, please update excel 2007 to include this. It is very important to have this function for us accountants! -- Rinke -- 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) | |||
| display negative number as zero | Excel Discussion (Misc queries) | |||
| I seem unable to display negative values with brackets | Excel Discussion (Misc queries) | |||
| How do I show negative number in brackets using excel? | Excel Worksheet Functions | |||
| How do I change the display of a negative number to just read 0? | Excel Discussion (Misc queries) | |||
Linear Mode
