value needed for all cells in a column

J

jms54

I have a column that is a date field. I enter the date at the head of this
column and want it to be copies all the way down the column. How do I do
this.

1/2/09
1/2/09
1/2/09

I want to make it so that someone only has to fill out this information 1
time and all records will get filled. Thanks
 
J

JE McGimpsey

jms54 said:
I have a column that is a date field. I enter the date at the head of this
column and want it to be copies all the way down the column. How do I do
this.

1/2/09
1/2/09
1/2/09

I want to make it so that someone only has to fill out this information 1
time and all records will get filled. Thanks

One way:

Select A2. Enter

=IF(A1="","",A1)

Copy A2 down as far as desired.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top