format the cells as Custom # ##0;-# ##0;



On 1 Cze, 10:51, "Fergal" wrote:
I have the following formula: =SUM(C9-E9-F9)
This formula is then dragged down for many rows and works perfectly except
for one thing, in the rows that have no data in them, the cell shows up as
£0.00. Is it possible to have it that the cell remains blank until data is
entered in the row?
I hope this makes sense to you,
Thank You for any replies.