T
tomek gomek
format pattern Standard;-Standard;"NIL"
i haven't English Excel so "standard" may be different, i don't know
tomek
i haven't English Excel so "standard" may be different, i don't know
tomek
How to format cell to display "NIL" if value of cell is zero in Ex
D
David Biddulph
Try General instead of Standard.
T
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
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