View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default How can I add a + sign to a positive result of a calculation?

Hi

Use a custom format for the cell of
+0;-0

Andy.

"PeterP9009" wrote in message
...
I am compiling a golf scorboard in Excel. I want the running totals to
display a positive sign (i.e. for over par - +5) as well as the under par
scores to sho negatives (which is well-documented). How do I do this?