| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
cell references
Perfect. Thanks Gord!
"Gord Dibben" wrote: Tim Re-format at least column X to General then re-enter the formula in X3. Gord Dibben MS Excel MVP On Mon, 26 Jun 2006 11:24:02 -0700, Tim in Ottawa wrote: Hi, new to excel and struggling with references. Column B is a list of names. I want these names to also appear in column X (ie. B3 name should appear in X3). I put the cursor in X3, type = in the funtion area, then click B3 and hit enter. =B3 then appears in cell X3 which seems to be the correct formula, but I want the name to appear. Both columns are set as text. Thanks, Tim. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Furmula Dependent Cell References | Excel Discussion (Misc queries) | |||
| Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
| Cell references change when entering new data | New Users to Excel | |||
| Absolute cell references and subsequent problems. | Excel Discussion (Misc queries) | |||
Threaded Mode
