Thanks so much John, that worked! Thats been a mystery to me for years, how
do you know how to do that?

"John Mansfield" wrote:

Try using a custom number format.

Go to Format - Cells. On the Number Tab choose Custom from the Category
option. Type in:

<#,##;#,##

--
John Mansfield




"Felicity" wrote:

How do you display or < signs on a chart, I am trying to put values on a
chart but some of them are <2 or 60 etc. These values are displayed as zero
on the chart. Is it possible to display values with < or signs before the
number?