Thread: How can I ge tmy sum to show the + sign for positive sums?
View Single Post
  #3   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?
If you have decimal places select C1 which is the formula cell and then right
click--Format CellsCustom and enter +#.00;-#.00

A1 = 1.21
B1 = 2.23
C1 = A1+B1


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