On Fri, 21 Dec 2007 22:45:45 -0000, "Sandy Mann"
wrote:

"Ron Rosenfeld" wrote in message
.. .
However, if you want it to display that way if you type in a 10, or a
number
less than 10, try this:

Format/Cells/Number/Custom Type: [<=10]"<10.00";0.00


Or if the OP wants to use the number as a number then perhaps:

[<=10]"< "#.00;0.00

He could still use his entry as a number with the formatting I recommended. It
just wouldn't be the same number being displayed.

And that is an option I considered.

But from the examples he posted, and the fact that these refer to laboratory
values, I suspect that the formatting for each cell will be different,
depending on the actual lab test being run.

It would look odd, and be incorrect in some sense of the word, to display a
result of <5.00 when the test is not capable of differentiating anything with a
value <10.00.

I would probably enter either a value equal to the minimum detectable value, or
a zero, but still have the display show < 'minimum detectable amount'
--ron