| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
In Excel trying to reference text that already is in other cel
Thanks, that did it. What confused me was that you have to do the formatting
BEFORE you enter anything into the cell. Changing the format afterwards won't fix the problem, but if you format first it does work. Thanks. BillR "JE McGimpsey" wrote: You will see this when you enter the formula in a cell that's formatted as Text. Format it as General or a number format, and reenter the formula... In article , BillR wrote: If I go into Sheet2!A1 and enter "=", then switch to Sheet1!A1 and hit enter, sometimes I will get the text contents of Sheet1!A1 to display in Sheet2!A1, but sometimes all I see in Sheet2!A1 is "=Sheet1!A1". Which is the formula if you will that has been entered. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem Using Excel datenumber as Text reference | Excel Worksheet Functions | |||
| How to enter an Excel cell reference into a line of text in Excel | Excel Worksheet Functions | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| How do I save Excel info without saving the reference cells? | Excel Discussion (Misc queries) | |||
| Excel should be able to map which cells reference each other. | Excel Worksheet Functions | |||
Threaded Mode
