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