NumberFormat instead of an IF
 

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.

NumberFormat instead of an IF
 

Hi,

Am Mon, 26 Nov 2012 09:26:38 -0800 (PST) schrieb
:

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
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

NumberFormat instead of an IF
 

Perfect, thanks!

Odd format, that.