Formulas Display as Text rather than calculating

**Puzzler** · 06-17-2012, 11:43 PM

Hi,

I have Excel 2007. I have a spread sheet that was given to me to modify. I find that when I enter a formula in a cell it displays as text rather than calculating. I have hunted in Help and can not find out how to correct this.

Thank you in advance for any help you can give me.

Bill

**protonLeah** · 06-18-2012, 12:10 AM

Try:
1. Excel options > Advanced > Display options for this worksheet > Show formulas in cells instead of their calculated results (verify: unchecked)
2. Verify cell format is "General"

**Puzzler** · 06-18-2012, 12:38 AM

Originally Posted by protonLeah

Try:
1. Excel options > Advanced > Display options for this worksheet > Show formulas in cells instead of their calculated results (verify: unchecked)
2. Verify cell format is "General"

Wow, thank you for the fast and accurate answer. It turns out that the cells were formatted as Text rather than General.

Thanks so much for the help.

Bill

**protonLeah** · 06-18-2012, 12:46 AM

You are welcome

Please mark your thread as Solved:
1. Click Thread Tools above your first post, select "Mark your thread as Solved". Or,
2. Click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.