NumberFormat instead of an IF

[maury.markowitz]

I have a column with a number that is either zero, or some other number >5

In the case where it's zero, I'd like it to say "None".

Can I do this with a NumberFormat?

I tried setting the zero formatter to various "None" with and without quotes, but it always displays a blank or gives me an error.

 

[Claus Busch]

Hi,

Am Mon, 26 Nov 2012 09:26:38 -0800 (PST) schrieb
(e-mail address removed):

I have a column with a number that is either zero, or some other number >5

In the case where it's zero, I'd like it to say "None".

try custom number format:
0;-0;"None"


Regards
Claus Busch

 

[maury.markowitz]

Perfect, thanks!

Odd format, that.