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

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
...

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

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
...

[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
...