Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping status on posed questions in Excel | Excel Discussion (Misc queries) | |||
Newby questions - simple (I hope) | Excel Discussion (Misc queries) | |||
Excel - how can I practice formulas on financial questions? | Excel Discussion (Misc queries) | |||
Help with what should be a simple formula | Excel Worksheet Functions | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) |