View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tomek gomek tomek gomek is offline
external usenet poster
 
Posts: 13
Default How to format cell to display "NIL" if value of cell is zero in Ex

format pattern Standard;-Standard;"NIL"

i haven't English Excel so "standard" may be different, i don't know

tomek

Użytkownik "Suyog" napisał w wiadomości
...