Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
negative numbers
How do I get a negative number to appear in red with a minus sign instead of
brackets or a minus sign in black? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
negative numbers
If the option doesn't appear in your Format/Cells/Number dialog, one way:
Choose Format/Cells/Number/Custom General;[red]-General;General In article , Flyguy wrote: How do I get a negative number to appear in red with a minus sign instead of brackets or a minus sign in black? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 : Convert Positive Numbers to Negative Numbers ? | Excel Discussion (Misc queries) | |||
Set negative numbers to zero. Do not calculate with negative valu | Excel Discussion (Misc queries) | |||
change 2000 cells (negative numbers) into positive numbers | Excel Worksheet Functions | |||
Excel Formula - Add column of numbers but ignore negative numbers | Excel Worksheet Functions | |||
convert negative numbers to positive numbers and vice versa | Excel Worksheet Functions |