Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel
How do I show negative numbers in brackets in Excel?
|
#2
|
|||
|
|||
One way:
Format/Cells/Number/Custom General_);(General) In article , "Ally" wrote: How do I show negative numbers in brackets in Excel? |
#3
|
|||
|
|||
Using Format Cells, Number, Category = Custom...
try #,##0.00;(#,##0.00) decimal places can be varied according to what you want "Ally" wrote: How do I show negative numbers in brackets in Excel? |
#4
|
|||
|
|||
Hi, Ally;
Format Cells Number Number and Format Cells Number Currency both have that option. -IanRoy "Ally" wrote: How do I show negative numbers in brackets in Excel? |
#5
|
|||
|
|||
Assuming brackets as being the "[]" characters, Format/Number/Custom, select
the #,##0_);(#,##0) format ant replace the (#,##0) with "["#,##0"]" Gary "Ally" wrote: How do I show negative numbers in brackets in Excel? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
VB Automation is Whacking out my Excel Environment | Excel Discussion (Misc queries) | |||
Excel 2000 file when opened in Excel 2003 generates errors? | Excel Discussion (Misc queries) | |||
Macro in Excel 2002 to save a workbook to a FTP location | Excel Discussion (Misc queries) |