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

hehe :)
i don't know how its name in excel english is.
in my excel (polish) this is "standardowy" ;)
i must install excel in english cause sometimes i have some problems when i
read posts on this group and this group is very useful

tomek

Użytkownik "David Biddulph" <groups [at] biddulph.org.uk napisał w
wiadomości ...
Try General instead of Standard.
--
David Biddulph

"tomek gomek" wrote in message
...
format pattern Standard;-Standard;"NIL"

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

tomek

Uzytkownik "Suyog" napisal w wiadomosci
...