Thread: Getting a positive percentage to have a + sign
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default Getting a positive percentage to have a + sign
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
Reply With QuoteReply With Quote