Questions should be simple please help
 

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!

Questions should be simple please help
 

Place the formula in a single.
Copy the cell
Select the other cells in the column
Paste
--
Gary''s Student


"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!

Questions should be simple please help
 

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!

Questions should be simple please help
 

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!