OK, i thought that what I said was clear but here goes again.

I have no problem seeing the formulas. That is easy. What I want is to be
able to see the actual values that the formula uses laid out (without going
to the watch window every time).

So, using the example that I first wrote:
I can easily see =(A1+B2)/C3*D4).
I want to see =(1+2)/3*4

Basically, I want a quick way to produce the same results as
="(" & A1 &" + "& B2 &") / "& C3 &" * "& D4



Obviously this is a simplistic example, the actual formulas point across
multiple sheets etc...

I am not sure how much more explicit or clear that I can be.



"Spiky" wrote:

I think you're right that we aren't communicating well.

F2 moves you into Edit mode in one cell.

But simpler for one cell at a time is to simply have the Formula Bar
showing and look up there to see the formula.

CTRL-` moves you into the Show Formulas view, which shows all the
formulas in the sheet. Although if they are long, it won't necessarily
show every character in the formula.

There is a UDF which is part of morefunc (search on download.com)
which will show formulas in a different cell. It's called FORMULATEXT,
and it simply shows a formula as the value in a cell. Like this:
=FORMULATEXT(A1) .....this will show whatever the formula looks like
in A1.