D
Don Wiss
I find Excel does a pretty good job of hiding the help for custom cell
formats. I found part of it, but I was unable to find the help for when you
want the format to vary depending on the cell value. I tried this:
[>=100]#,##0;[<100]0.000;;"-"
Except when the value is zero I get 0.000, which means the ending of the
above isn't working. So how do I get no decimals when >100, three decimals
when less, and a dash when 0?
Don <www.donwiss.com> (e-mail link at home page bottom).
formats. I found part of it, but I was unable to find the help for when you
want the format to vary depending on the cell value. I tried this:
[>=100]#,##0;[<100]0.000;;"-"
Except when the value is zero I get 0.000, which means the ending of the
above isn't working. So how do I get no decimals when >100, three decimals
when less, and a dash when 0?
Don <www.donwiss.com> (e-mail link at home page bottom).