Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Color a cell and a value is automatically assigned to that color. | Excel Worksheet Functions | |||
Problem with IF condition or vector lookup? | Excel Worksheet Functions | |||
using content of a cell in a formula in another cell | Excel Worksheet Functions | |||
Transferring cell content between workbooks using cell references | Excel Discussion (Misc queries) |