Here is what I have in my worksheet:
A1=2 B1=3 C1=A1+B1
I want the actual cell to show
5 but when I copy
C1 I want the formula in the cell to show
5 is there a way to do this?
Try this in cell C1:
This will give you the actual contents of A1 followed by a plus sign followed by the actual contents of B1, so in your example it where
Excel doesn't see things that way. It uses the cell address, i.e.
The only way I know to do what you want it to actually type
You can do this using F9 in the formula bar: If you select/highlight any term in your formula and press F9, it will get evaluated and the value is shown instead of the term.
E.g. in your example, if you highlight
Having said that, I'm not really sure I can see any use of the above technique, above from quickly checking/debugging the result of a complex formula. Though for this, the Evaluate Formula functionality (in the Formulas tab in Formula Auditing) is much better suited...
I hope I'm providing a reasonable alternative to what you've asked for. The formulas below will allow you to show the cell address and formula in another cell. That would not entail copying the original formula cell to another cell and have it show its formula rather than its value, but instead using specialized formulas in other cells to get the job done.
To show the cell address, use the following formula (I happened to use cell C12 as input to this formula):