|Mike, didn't know about that method. |
I played around with it a bit and the first thing I noticed was that (in 2003 at least) after I pasted your format string into the Custom format box, and then went back and looked at it later, it read:
Just interesting, that's all.
re: if your number falls outside the range you have specified...it simply disappears.
I assume you know this, but for the benefit of others, I'll pass along what else I learned...
If you add a ;General at the end of the string, the "disappeared" numbers (i.e. numbers outside the specified range) show up again.
To see numbers 10 <= n < 20 use:
And finally, riddle me this:
Exactly which numbers would be outside your range of <10, >= 10? ;-)