i edit a formula in excel then the cell no longer displays the answer but

the whole formula, why is this happening and how can i fix it?

1. make sure formula does not start with an apostrophy

'=A1+B1 will not compute

2. make sure cell is not formatted as text. Pull-down

Format > Cells... > Number General

--

Gary''s Student

'=A1+B1 will not compute

2. make sure cell is not formatted as text. Pull-down

Format > Cells... > Number General

--

Gary''s Student

Saved from a previous post...

Excel likes to help.

Try this on a test worksheet.

Select A1 and hit ctrl-; (to put the date in the cell)

now select B1 and type: =a1

Notice that excel changed the format of B1 to match the format in A1.

Now format D1 as Text.

put ASDF in D1

put =D1 in E1

You see ASDF.

With E1 selected, hit the F2 key and then enter (to pretend that you're changing

the formula).

Excel has "helped" you by changing that cell's format to text.

I don't know of any way of changing this behavior.

I just select the cell, and reformat it to General (or whatever I wanted). I

hit F2 and then enter (to reenter that formula).

Sometimes this feature is nice, sometimes it ain't.

--

Dave Peterson

Excel likes to help.

Try this on a test worksheet.

Select A1 and hit ctrl-; (to put the date in the cell)

now select B1 and type: =a1

Notice that excel changed the format of B1 to match the format in A1.

Now format D1 as Text.

put ASDF in D1

put =D1 in E1

You see ASDF.

With E1 selected, hit the F2 key and then enter (to pretend that you're changing

the formula).

Excel has "helped" you by changing that cell's format to text.

I don't know of any way of changing this behavior.

I just select the cell, and reformat it to General (or whatever I wanted). I

hit F2 and then enter (to reenter that formula).

Sometimes this feature is nice, sometimes it ain't.

--

Dave Peterson

1. Can you use a formula to edit another formula in excel?

2. Excel Formula displays text of formula

3. How do I get just 1 cell to display it's formulae not whole sheet?

4. How do I get just 1 cell to display it's formulae not whole sh

5. insert formula using VB - displays formula as string, not result

6. sum formula not working, producing incorrect answers Excel 200

7. Formula displays result in formula box but not in cell

8. Why doen't PasteSpecial, Formulas not display formula in cell?

9. Want to display financial formula result... not the formula

10. Cell displays formula not the result of the formula

11. Update Excel cell in formula not refreshing answer cell

12. EXCEL ANSWER TO FORMULA DOES NOT SHOW UP

13. help. Excel shows formulas, not answers

14. Text formula results do not display - Formula is UNchecked in View

15. Formula displays result in formula box but not in cell

3 post • Page:**1** of **1**