ExcelBanter - copying content of cell automatically to multiple cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - copying content of cell automatically to multiple cells (https://www.excelbanter.com/excel-worksheet-functions/29267-copying-content-cell-automatically-multiple-cells.html)

copying content of cell automatically to multiple cells

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

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