|The only way to show a "formula" in a cell is to tell Excel that the value in the cell is Text. You can do this by putting a single quote before the value, e.g. |
Of course, since the value in the cell is now Text, it will not be evaluated by Excel. In other words, it's no longer a formula.
You can't have it both ways.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.