Posted by PDE on September 01, 2000 7:58 PM
I am just learning Excel. I have created a spread sheet with a formula in a cell that adds numbers in cells E through J and I want the total in cell K. It works OK, but the figures in the column that have no numbers entered in the preceding cells show up as "zero". How can I make the cell just show blank without zeros all the way down the column. I have the same situation in my checkbook register. It shows the last figure all the way down the column.
I hope this question is not too elementary for you to answer.
Thanks in Advance.