Questions should be simple please help

B

babiigirl

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

Gary''s Student

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

Don Guillett

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

CLR

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
Click to expand...

Vaya con Dios,
Chuck, CABGx3
 
Top