How To Copy Text To Other Cells

S

sumesh56

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 th
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 4100
instead of Apr-1
 
G

Gord Dibben

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 Format>Number>Date to see various available
formats.


Gord
 
G

Gord Dibben

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
 
S

Spencer101

sumesh56;1600575 said:
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 th
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 4100
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 dow
versions
 
S

sumesh56

'GS[_2_ said:
;1600584']Try..

Select A2:A
Type =$A$
Press Ctrl+Ente

--
Garr

Free usenet access at http://www.eternal-september.or
ClassicVB Users Regroup
comp.lang.basic.visual.mis
microsoft.public.vb.general.discussio

thank you very much for the suggestion. it works. but no need for th
absolute cell reference. it works like thi
i typed mar-12 in A
then i select A2 :A1
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 automaticall
appear in cells A1:A10. thanks once again
 
G

GS

sumesh56 laid this down on his screen :
'GS[_2_ said:
;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
 

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