| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Show a cell's formula in text format in a linked cell
I want to show the formula for a specific cell in text format in another cell.
For example, if cell A1 has a simple formula of "=10+64" (but only shows an answer of "74"), how can i link this cell to B1, so that B1 only shows as text "10+64" or " =10+64", instead of the actual answer? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| bold text of referenced cell show in formula cell | Excel Worksheet Functions | |||
| Formula to recognize if another cell's conditional format is true | Excel Discussion (Misc queries) | |||
| Why does formula show rather than results (not in text format) | Excel Worksheet Functions | |||
| how to get the formula shown in linked cell's names | Excel Programming | |||
| How do I use a cell's text, "A1", and put it in a formula? | Excel Worksheet Functions | |||
Threaded Mode
