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

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Show actual values added instead of cell references? (=A1+A4 shows as =10+2 in cell) (https://www.excelbanter.com/excel-programming/437847-re-show-actual-values-added-instead-cell-references-%3Da1-a4-shows-%3D10-2-cell.html)

Tim Williams[_2_]

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

Why would you want to do this?

Tim

"Naji" wrote in message
...
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?

All times are GMT +1. The time now is 12:50 AM.