View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MikeR MikeR is offline
external usenet poster
 
Posts: 11
Default How can I display formula values instead of the formula?

Dan G wrote:
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


Mismatched parens? How about =(A1+B2)/C3*B4
Mike