On fly:

Create an UDF
Public Function ShowFormula(MyRange As Range)
ShowFormula = MyRange.Formula
End Function

P.e. into cell A1 enter the some formula
Into cell B1 enter the formula
=ShowFormula(A1)


Arvi Laanemets


"journey" wrote in message
...
Hi

I wanted to display the formulas permanently besides a calculated
value. When I go to ToolsOptionsview, click on the window options
Formulas, I achieve the result however the value with the formulas in
it also turn to formulas which is not the result i wanted.

Could someone pls advice.

Thanks