0

I have an excel formula: =(3+2)/2
which outputs: 2.5
I want the cell to appear exactly like: (3+2)/2
and also use it in calculations. Is there a way to do this?

fawad aslam
  • 1

1 Answers1

1

Under the formula Tab,

Look for an option called 'Show Formulas' use this to turn on/off.

You can also use a formula to view another cells exact forumula, depending on which version of excel you use:

=FORMULATEXT(A1)

Will deiplay the formula form cell A1

PeterH
  • 7,595