| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show actual values added instead of cell references? (=A1+A4 shows as=10+2 in cell)
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show actual values added instead of cell references? (=A1+A4 shows as =10+2 in cell)
See your other thread. Please do no multi-post.
Regards, Fred "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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show actual values added instead of cell references? (=A1+A4shows as =10+2 in cell)
Which other thread?
On Dec 29, 2:15*pm, "Fred Smith" wrote: See your other thread. Please do no multi-post. Regards, Fred "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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show actual values added instead of cell references? (=A1+A4 shows as =10+2 in cell)
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 "Naji" wrote in message ... Which other thread? On Dec 29, 2:15 pm, "Fred Smith" wrote: See your other thread. Please do no multi-post. Regards, Fred "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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Show actual values added instead of cell references? (=A1+A4 shows as =10+2 in cell)
....or, at least, cross posted, so that the answer was visible in each group.
-- Gary Keramidas Excel 2003 "Fred Smith" wrote in message ... 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 "Naji" wrote in message ... Which other thread? On Dec 29, 2:15 pm, "Fred Smith" wrote: See your other thread. Please do no multi-post. Regards, Fred "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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically show cell references of formulas | Excel Discussion (Misc queries) | |||
| Different answers when using cell references as opposed to actual | Excel Worksheet Functions | |||
| double click cell to show formula references | Excel Discussion (Misc queries) | |||
| how to replace cell references with actual numbers | Excel Discussion (Misc queries) | |||
| How to show actual values in a pivot grap/table | Charts and Charting in Excel | |||
![Naji[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
