Don't want formulas to display

  • Thread starter Thread starter HT
  • Start date Start date
H

HT

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

Thank you.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top