formula displayed instead of the result ???


G

Guest

sometimes when entering a formula the formula is displayed instead of the
result. Why? It only occurs in some cells and not all and the formula options
check box set in "tools/options/view/windows option" is not ticked.
Can anybody suggest why?
 
Ad

Advertisements

J

JulieD

Hi

this occurs when the cell has been pre-formatted to text. to fix, copy a
blank unused cell (even from another sheet), click on the misbehaving cell
and choose edit / paste special ADD

this should sort it out.

Cheers
JulieD
 
Ad

Advertisements

G

Gord Dibben

Most likely caused by having the cell(s) pre-formatted as Text.

With cell selected, hit F2 then ENTER.

If you have a great whack of these, select them and

Edit>Replace

What: =
With: =

Replace all.

Gord Dibben Excel MVP

On Sun, 21 Nov 2004 20:09:03 -0800, Purple Angel <Purple
 
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

Cell displays formula instead of the formula's result 3
View formula result instead of formula 4
how do I display the formula result instead of the formula itself. 3
SUM formula generating formula instead of result. 2
Formulas appear in cell instead of formula result 3
Diplaying results of a formula instead of the formula itself 1
Formula text showing instead of result... 7
Cells showing formulas instead of results 2

Top