Custom number format in Excel 03 help

_Andy_

Hi

I have made a customer number format (in a data label on a graph) which works fine for changing, say, 25,000 into £25k.
But I want nothing do display if the figure is 0..i.e rather than £k at the moment, no data label.

Any ideas on how to do this would be appreciated
cheers

m5rcc

Tools > Options > View tab.

Do one of the following:
To display zero (0) values in cells, select the Zero values check box OR to display zero values as blank cells, clear the check box.

_Andy_

Thanks but its not within a cell, it's the data labels themselves, I'm sure there's some way within the custom number to stipulate what to do if a number is greater/less than X but not sure how
cheers

EchoLocation

Try adding #;;; as part of your number format.

_Andy_

Legend, thanks so much