Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Show actual values added instead of cell references? (=A1+A4 shows as=10+2 in cell) | Excel Discussion (Misc queries) | |||
Show actual values added instead of cell references? (=A1+A4 showsas =10+2 in cell) | Excel Worksheet Functions | |||
Different answers when using cell references as opposed to actual | Excel Worksheet Functions | |||
how to replace cell references with actual numbers | Excel Discussion (Misc queries) | |||
how to replace cell references with actual numbers | Excel Programming |