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

N

Naji

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?
 
F

Fred Smith

All the other groups you posted to. Now you know why multi-posting doesn't
work. You waste your own time, the time of potential problem solvers and
disperse your responses. You had a much better chance of getting a solution
had you posted to only one group.

Regards,
Fred

Which other thread?
 
G

Gary Keramidas

....or, at least, cross posted, so that the answer was visible in each group.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell) 3
Search cell value in same column 3
Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell) 6
Dynamic pointing to a cell 0
Inserting a row within a range that is defined in a sum function 0
Looking to added up based on a character from cell range 1
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Show a cell's formula in text format in a linked cell 2

Top