View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
BVB1200 BVB1200 is offline
external usenet poster
 
Posts: 1
Default I would like a cell to show a + or - sign before number.

When showing numbers in a cell I would like positive numbers to be preceeded
with a + sign. I would like negative numbers to be preceeded by a - sign. How
can I format to do this automatically?