Cell displays formula and not result
 

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.

Cell displays formula and not result
 

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

<Data <TextToColumns <Finish

And your formulas should now work.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"BP" wrote in message
...
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.

Cell displays formula and not result
 

Worked a treat .... thanks

"ragdyer" wrote:

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

<Data <TextToColumns <Finish

And your formulas should now work.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"BP" wrote in message
...
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.

Cell displays formula and not result
 

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

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"BP" wrote in message
...
Worked a treat .... thanks

"ragdyer" wrote:

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

<Data <TextToColumns <Finish

And your formulas should now work.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"BP" wrote in message
...
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.