View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Nelson B. Nelson B. is offline
external usenet poster
 
Posts: 35
Default Getting a positive percentage to have a + sign

Got it to work. Thanks for everybody's help

"Dave Peterson" wrote:

You can use a custom format variation of:

+0.00%;-0.00%;0%;@

(positive;negative;zero;text)



Nelson B. wrote:

I often show the difference between relative percentages and would like to
have a positive number show up as +9%. Currently I only have -9% and 9%.
Any help would be appreciated.


--

Dave Peterson