Frustrating Issue!!!

[CHC Consulting LLC]

I am entering a simple formula in a cell and instead of computing the formula and dislplaying the result, it just displays the formula in the cell.

Here is my formula....

<table x:str="" style="border-collapse: collapse; width: 63pt;" border="0" cellpadding="0" cellspacing="0" width="84"><col style="width: 63pt;" width="84"><tbody><tr style="height: 20.1pt;" height="26"> <td class="xl65" style="height: 20.1pt; width: 63pt;" height="26" width="84">=INQUIRY!B3</td> </tr></tbody></table>
Any ideas?

 

[Beate Schmitz]

Hello,

is the cell formatted as text?

 

[Aladin Akyurek]

I am entering a simple formula in a cell and instead of computing the formula and dislplaying the result, it just displays the formula in the cell.

Here is my formula....

<TABLE style="WIDTH: 63pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=84 x:str=""><COLGROUP><COL style="WIDTH: 63pt" width=84><TBODY><TR style="HEIGHT: 20.1pt" height=26><TD style="WIDTH: 63pt; HEIGHT: 20.1pt" class=xl65 height=26 width=84>=INQUIRY!B3</TD></TR></TBODY></TABLE>
Any ideas?

Select the formula cell.
Format the formula cell as General.
And hit F2.

Or run...

Edit|Replace.
Set Find What to: =
Set Replace With to: =
Activate the Replace All button.

 

[gholt]

You could also do text to columns, under the data menu. Just follow it through and make it a general data.

 

[CHC Consulting LLC]

Great thx!!!!