Excel 2000

I have been formatting an excel table where a line is inserted and formulas
copied to cells in the newly inserted line.

However, the cells in the new line are showing zero's, while the cells from
which the formulas are copied do not show any zeros/values, unless data has
been entered.

As a result, I have a number of lines in the table where some of the lines
do not show any zero's/values, and one line that does show zero's/values.

I have tried a number of formatting options to try to have the newly
inserted line showing the same no zero's/values, but without sucess.

If I right-click on one of the original cells in the line above, select
'format cells' the Number format is 'number' and the Sample bar shows as
blank.

If I right-click on one of the cells in the new line, select 'format cells'
the format for Number is the same, but, the Sample bar shows a zero value
with one decimal point.

What I am attempting to do is show the cell as blank unless data is entered
in other cells, and then the formula result will show.