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).