| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to format cell to display "NIL" if value of cell is zero in Ex
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 ... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
[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 ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format cell to display "Y" or "N"when entering a 1 or zero | Excel Discussion (Misc queries) | |||
| Help!!! Enter "7" in a cell and Excel changes the "7" to "11" immediately!!! | Excel Discussion (Misc queries) | |||
| Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
| How would I display the word "Paid" if the value of another cell= | Excel Worksheet Functions | |||
| " / " Changing Decimal number format to Fraction on Protected Cell | Excel Worksheet Functions | |||
Linear Mode
