G Guest Oct 20, 2007 #1 How do I get a negative number to appear in red with a minus sign instead of brackets or a minus sign in black?
How do I get a negative number to appear in red with a minus sign instead of brackets or a minus sign in black?
J JE McGimpsey Oct 20, 2007 #2 If the option doesn't appear in your Format/Cells/Number dialog, one way: Choose Format/Cells/Number/Custom General;[red]-General;General
If the option doesn't appear in your Format/Cells/Number dialog, one way: Choose Format/Cells/Number/Custom General;[red]-General;General