Formula Display

  • Thread starter Thread starter cesar3000gt
  • Start date Start date
C

cesar3000gt

Is there a way to format a cell to display a formula
rather than its value and then have the value displayed or
referenced by another cell?

Thanks much.
 
[email protected] said:
Is there a way to format a cell to display a formula
rather than its value and then have the value displayed or
referenced by another cell?
Click to expand...

One way:
Suppose you have a formula in a cell as normal, which will display the
result.
Format an adjacent cell as text.
Select the cell with the formula.
Highlight the formula in the formula bar and use Ctrl+C.
Press Esc.
Select the text-formatted cell.
Click in the formula bar and use Ctrl+V.
Then press enter.
This will give you a text version of the formula.
 
Hi!

I tend to use a UDF:

Function GETFORMULA(cell As Range) As String
GETFORMULA = cell.Formula
End Function

=GETFORMULA(A1)
Returns the formula in A1

It's not very sophisticated in terms of what can be achieved but it's
still one of my most used UDFs.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
in message news:[email protected]...
 
Back
Top