Hi,

Try this custom number format.

[<2]"<"#;[60]""#;0

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Felicity" wrote in message
...
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?