Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell)
 

Check one of your other posts.

Naji wrote:

Is there a way to do this via VBA or formula?

I want to show the values that are added instead of the cell
references. Let's say I want to Add use a cell to calculate
=A1+A4...with A1=10 and A4 = 2, I want the cell result to be 12
however the formula to be =10+2 instead of =A1+A4...is this possible?

--

Dave Peterson

Show actual values added instead of cell references? (=A1+A4shows as =10+2 in cell)
 

On Dec 29, 2:26*pm, Dave Peterson wrote:
Check one of your other posts.

Naji wrote:

Is there a way to do this via VBA or formula?

I want to show the values that are added instead of the cell
references. Let's say I want to Add use a cell to calculate
=A1+A4...with A1=10 and A4 = 2, I want the cell result to be 12
however the formula to be =10+2 instead of =A1+A4...is this possible?

--

Dave Peterson

I did check my other posts. No response :( . Should I delete the two
others before being recognized?