Show actual values added instead of cell references? (=A1+A4shows as =10+2 in cell)
On Dec 29, 1:24*pm, Naji wrote:
Is this even possible?
I have the following:
A1 *=A2 (Shows result of 10)
A2 *10
A3
A4 =A5 (Shows Result of 2)
A5 2
A7 =10+2 (Shows result of 27)
Is there a way to show the formula in A7 as =10+2 instead of having it
=A2+A5 ??? Thanks a bunch!
I know this is possible by highlighting the A2 and pushing F9 then
highlighting the A5 portion of the formula and pushing F9...but is
there a way to do this via formula or vba?
|