Questions should be simple please help

[Guest]

I have to very brief questions, how to apply a formula to a whole column? And
if you want a box to be blank but it comes up as 01/00/00 how do you get rid
of that?
Please help thanks!

 

[Guest]

Place the formula in a single.
Copy the cell
Select the other cells in the column
Paste

 

[Don Guillett]

You should always post your formula. Just drag down and use an if
=if(a2="","",a2)

 

[Guest]

If you have data in A1:C30 and the formula is in D1, then select D1 and
douple-click on the little black square in the lower right corner of D1 and
the formula will automatically copy down column D as far as you have data in
column C, in this case, to D30.........

For your second question, right-click on that cell > FormatCells > NumberTab

General > OK

Vaya con Dios,
Chuck, CABGx3