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



"babiigirl" wrote:

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!