How do I get a cell to show the result instead of the formula?


G

Guest

I have gone to Tools -> Options and formulas are unchecked. However, I
cannot get one particular cell to display results. It will only display
formulas. For example, if I simply reference another cell in the sheet, the
"=A1" reference shows up rather than the value of cell A1.
 
Ad

Advertisements

A

Arvi Laanemets

Hi

The cell is formatted as text. Format it as General (or number, or date) and
re-enter the formula (activate the cell, press F2, and then Enter)


Arvi Laanemets
 
Ad

Advertisements

G

Guest

Try this:
Select the cell
Format>Cells>Number tab
Category: General (it's probably set to Text right now)
Click the [OK] button.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
You must log in or register to reply here.

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

Similar Threads

Cells showing formulas instead of results 2
Formula text showing instead of result... 7
Formulas appear in cell instead of formula result 3
Cell displays formula instead of the formula's result 3
how do I display the formula result instead of the formula itself. 3
My formula show up in the cell instead of a resulting value 2
Why does forumula show in cell instead of formula result? 2
Cell shows formula eg ='Sheet21'!F3 instead of result 1

Top