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!
==============================================


"PAUL GRAZIDE" wrote in message
...
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