How to format cell to display "NIL" if value of cell is zero in Ex

[Guest]

 

[tomek gomek]

format pattern Standard;-Standard;"NIL"

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

tomek

 

[David Biddulph]

Try General instead of Standard.

 

[tomek gomek]

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