View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] maury.markowitz@gmail.com is offline
external usenet poster
 
Posts: 3
Default 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.