apologies if this has been posted b4.. i have looked thru quite a few pages but cant see what i am looking for...
i have a simple s/sheet with simple =sum formulas on it, just calculating over time hours for each month on a day to day basis... when i copy the formula to the cells that it needs to be in... a 0 goes in the blank cell...
and then when i start to input numbers the entire spreadsheet populates..
my question is... how do i stop the 0's and other calcualtions appearing and just leave blank cells...until i need them to be filled with the correct data...
hope i have explained that clearly enough
thanks in advance
m.
i have a simple s/sheet with simple =sum formulas on it, just calculating over time hours for each month on a day to day basis... when i copy the formula to the cells that it needs to be in... a 0 goes in the blank cell...
and then when i start to input numbers the entire spreadsheet populates..
my question is... how do i stop the 0's and other calcualtions appearing and just leave blank cells...until i need them to be filled with the correct data...
hope i have explained that clearly enough
thanks in advance
m.
