Cell displays formula and not result

[Guest]

A part of my spreadsheet will only display the formula, not the result. I can
oddly change the format by:

1. Re-fomat cell C12 to be "general" format
2. Then click off that cell to another cell.
3. Go back to cell c12 and double click on the cell.
4. Hit "enter"

When I set up a trace for the above, this did show that the formula includes
the ' or " preceding the = sign, but I cannot work out how to change this
through excel.

Appreciate any ideas.

 

[ragdyer]

Select the cells with the "bad" formulas, then:

<Data> <TextToColumns> <Finish>

And your formulas should now work.

 

[Guest]

Worked a treat .... thanks

Select the cells with the "bad" formulas, then:

<Data> <TextToColumns> <Finish>

And your formulas should now work.

 

[RagDyeR]

You're welcome, and appreciate the feed-back.