Posted to microsoft.public.excel.worksheet.functions

[email protected] maury.markowitz@gmail.com is offline

external usenet poster

Posts: 3

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
.numberformat Q	Aaron	Excel Worksheet Functions	4	December 18th 09 02:15 AM
Numberformat	Basta1980	Excel Programming	7	October 30th 09 10:01 AM
NumberFormat	TSW632	Excel Programming	1	October 31st 08 10:45 AM
NumberFormat	RBeau	Excel Programming	0	February 1st 08 11:42 PM
VBA NumberFormat	Digit	Excel Programming	1	January 30th 05 02:30 PM

All times are GMT +1. The time now is 07:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us