MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds


  Asked By: Luana    Date: Dec 11    Category: MS Office    Views: 961

I want help from you for following.

In Excel Sheet When I type as 0 (Zero) at any cell, it must auto shows as

In short value of 0 treat as "NIL".

How it is possible



3 Answers Found

Answer #1    Answered By: Robin Bailey     Answered On: Dec 11

A simple, non programming way, is to change  your Auto-Correct options,
found under the Tools menu bar.

Add a new entry for 0 = NIL

Answer #2    Answered By: Oscar Evans     Answered On: Dec 11

Thanks for reply and support.......................

Answer #3    Answered By: Michael Evans     Answered On: Dec 11

To keep the cell  value as zero but display the word NIL, try a custom format.
Select all the cells on your worksheet, then select Format >> Cells >> on the
Number tab, choose the Custom category. Enter a custom format like the


Click OK. The above example doesn't display decimals. You could edit it before
applying it (the following version displays 2 decimal places), or change
individual cells.


Either way, if you just enter 0 in a cell, it will display as NIL but still
contain the value 0.

Didn't find what you were looking for? Find more on AUTO CHANGE VALUE IN CELL Or get search suggestion and latest updates.