View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dean[_8_] Dean[_8_] is offline
external usenet poster
 
Posts: 407
Default custom formats for plus or minus

This is an easy one:

"IRR guess = "0%

I tried this as a custom format, but it doesn't work if the value is
negative. In fact, if the value is minus 3%, it ends up showing as (with
the negative sign showing up in front of the label):

-IRR guess = 3%

What do I do to the custom formatting to allow it to show negative values as
negative?

Thanks!
Dean