Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
babiigirl
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keeping status on posed questions in Excel Jaydubs Excel Discussion (Misc queries) 5 June 8th 06 05:08 AM
Newby questions - simple (I hope) Nooby Excel Discussion (Misc queries) 1 March 8th 06 06:04 PM
Excel - how can I practice formulas on financial questions? flamingformulas Excel Discussion (Misc queries) 4 February 20th 06 04:18 PM
Help with what should be a simple formula B Millar via OfficeKB.com Excel Worksheet Functions 2 June 16th 05 04:18 PM
Pivot Table for survey data w/ questions as Rows & poss answrs as pfwebadmin Excel Discussion (Misc queries) 0 May 17th 05 02:31 PM


All times are GMT +1. The time now is 12:11 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"