Thread: How can I ge tmy sum to show the + sign for positive sums?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default How can I ge tmy sum to show the + sign for positive sums?
Select the cells where you want to apply the formatting and then in Format
Cells Number Category Custom Type

+#;-#

If this post helps click Yes
---------------
Jacob Skaria


"Karie" wrote:

I am summing up two cells and want the + sign to show for the positive sums
and the - sign to show for the - signs....anyone know how this is possible?
Reply With QuoteReply With Quote