Don't want formulas to display

[HT]

How can I view a worksheet with just the results and not the forumlas
showing?

Thank you.

 

[Don]

Tools/Options/View/...uncheck "Formulas" in "Window
Options"

 

[donbow]

Try Tools, Options, and untick the formulas box

 

[Gord Dibben]

HT

If you are not in "Formula View" and your formulas are showing, perhaps the
cells were formatted as Text before you typed them in?

Re-format to General then F2>Enter to re-enter the formulas.

If you have a great whack of these.....select all cells then

Edit>Replace

what: =
with: =

Replace all.

Gord Dibben Excel MVP