Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
NumberFormat instead of an IF
Perfect, thanks!
Odd format, that. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
.numberformat Q | Excel Worksheet Functions | |||
Numberformat | Excel Programming | |||
NumberFormat | Excel Programming | |||
NumberFormat | Excel Programming | |||
VBA NumberFormat | Excel Programming |