close

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 quot;Unchangedquot;

But when I apply the following custom format--gt; [gt;1] ?#;[lt;-1] (?#); quot;Unchquot;

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄