i have a data <march2012 in cell A1
i want to copy this data to cell A2:A5. what i mean is when i edit the data in A1 it should automatically come to A2:A5.
i do the following

highlight cells a2:a5
=A1
but i don't get the results.



i type April 2012 in A1
April 2012 automatically becomes Apr-12.
when i copy pastespl values---- in cells A2:A5---- it gives 41000 instead of Apr-12

In A2 enter =$A$1 note the $ signs which makes the reference
Absolute

Drag/copy down to A5 using the fill handle.

Format the cells for what you want to see.

Typing April 2012 without a day will give you April 1 2012

Format as you wish.

If you want a date like April 7 2012 you must enter the day also.

Type April 7 and enter to get April 7 2012

The underlying value of a date is a 5 digit number. 41000 is the
mathematical equivalent of April 1 2012

You must format all the cells as you wish.

mmm dd yyyy or similar.

Select the cells and FormatNumberDate to see various available
formats.


Gord


On Sat, 7 Apr 2012 01:14:15 +0000, sumesh56
wrote:


i have a data <march2012 in cell A1
i want to copy this data to cell A2:A5. what i mean is when i edit the
data in A1 it should automatically come to A2:A5.
i do the following

highlight cells a2:a5
=A1
but i don't get the results.



i type April 2012 in A1
April 2012 automatically becomes Apr-12.
when i copy pastespl values---- in cells A2:A5---- it gives 41000
instead of Apr-12

Try...

Select A2:A5
Type =$A$1
Press Ctrl+Enter

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

I got thinking..........

Maybe you don't want a real date at all. you just want April 2012 as
text.

In that case start the text with an apostrophe like 'April 2012

The apostrophe won't be visible in the cell.


Gord

On Fri, 06 Apr 2012 19:20:03 -0700, Gord Dibben
wrote:

In A2 enter =$A$1 note the $ signs which makes the reference
Absolute

Drag/copy down to A5 using the fill handle.

Format the cells for what you want to see.

Typing April 2012 without a day will give you April 1 2012

Format as you wish.

If you want a date like April 7 2012 you must enter the day also.

Type April 7 and enter to get April 7 2012

The underlying value of a date is a 5 digit number. 41000 is the
mathematical equivalent of April 1 2012

You must format all the cells as you wish.

mmm dd yyyy or similar.

Select the cells and FormatNumberDate to see various available
formats.


Gord


On Sat, 7 Apr 2012 01:14:15 +0000, sumesh56
wrote:


i have a data <march2012 in cell A1
i want to copy this data to cell A2:A5. what i mean is when i edit the
data in A1 it should automatically come to A2:A5.
i do the following

highlight cells a2:a5
=A1
but i don't get the results.



i type April 2012 in A1
April 2012 automatically becomes Apr-12.
when i copy pastespl values---- in cells A2:A5---- it gives 41000
instead of Apr-12

Highlight all the cells you need.
Go to "Format Cells / Custom" and in the "Type" box enter "MMMM YYYY" without the quotes then press OK.

Put in your dates and they will show in full rather than the cut down versions.

thank you very much for the suggestion. it works. but no need for the absolute cell reference. it works like this
i typed mar-12 in A1
then i select A2 :A10
then i typed = then i clicked on cell A1 then press control and enter. done!
now if i change the content in cell A1 to jul-12 it will automatically appear in cells A1:A10. thanks once again.

sumesh56 laid this down on his screen :
'GS[_2_ Wrote:
;1600584']Try...

Select A2:A5
Type =$A$1
Press Ctrl+Enter

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

thank you very much for the suggestion. it works. but no need for the
absolute cell reference. it works like this
i typed mar-12 in A1
then i select A2 :A10
then i typed = then i clicked on cell A1 then press control and enter.
done!
now if i change the content in cell A1 to jul-12 it will automatically
appear in cells A1:A10. thanks once again.

That approach results in each cell referencing the cell above, NOT A1.
So A3's formula is =A2; A4's formula is =A3; and so on.

My sugeestion makes the formula in all cell ref A1...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion