View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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?