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

--
Don Guillett
SalesAid Software

"babiigirl" wrote in message
...
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!