View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sfrancoe2
 
Posts: n/a
Default Strange Result using custom number format

I am trying to apply a custom number format that returns the following
results..

If the number is less than -1 it is formatted as (?#)
If the number is greather than +1 is is formatted as +?#
If it is between -1 and 1 the result is text saying "Unchanged"

But when I apply the following custom format-- [1]+?#;[<-1] (?#); "Unch"

I get a strange result for numbers between -1 and 1. I get -Unch. I can't
figure out why it puts the - in front of the text.

Thanks