copying content of cell automatically to multiple cells

P

PAUL GRAZIDE

How do I enter a number once and have it copy automatically to multiple
cells. I tried formatting the cells as text and using the =T() function.
This worked fine for the first copy but not for the 3rd and 4th copy. What
is the correct way to do this?

a1 k2 m2
123 =t(a1) =t(a1) ......etc k2 is ok, other no data just
the formula

thanks in advance
 
R

RagDyeR

If you want the *number* copied:

=$A$1

If you want the number copied and transformed to *text*:

=TEXT($A$1,"####")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


How do I enter a number once and have it copy automatically to multiple
cells. I tried formatting the cells as text and using the =T() function.
This worked fine for the first copy but not for the 3rd and 4th copy. What
is the correct way to do this?

a1 k2 m2
123 =t(a1) =t(a1) ......etc k2 is ok, other no data just
the formula

thanks in advance
 
Top