View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default display plus sign on plus numbers in Excel

You could give it a custom format via
format|Cells|number tab
Custom category
type:
+General;-General;0;@

positive format;negative format;0;text
is the order of that string.


tnoble wrote:

I am trying to make number greater than 0 show the plus sign.


--

Dave Peterson