but this will create a problem while summing the cells.Say at cell D10 the formula is = D2+D7+D9 as this formula will treatthe "Nil" as text and not number.