Hi All
I have cell A1 = 1; A2=2
A3 = A1 + A2 = 3
Formula Bar display at A3 : = A1 + A2
Is there anyway to change to:
A3 = 1 + 2
Thanks in advance.
Hi All
I have cell A1 = 1; A2=2
A3 = A1 + A2 = 3
Formula Bar display at A3 : = A1 + A2
Is there anyway to change to:
A3 = 1 + 2
Thanks in advance.
No, that's not how Excel works.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
The closest thing I can think of to what you are describing is the Formula Evaluation tool. This is a debugging tool that brings up the cell formula in a dialog, then, as you step through the formula, shows you the values of cell references and the results of each calculation step. So, for the simple formula you posted, the dialog would first show A1+A2, then it would show that A1 is 1, A2 is 2, then it would show the result of the sum as 3.
Is that useful?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks