<snip>
When you format a cell as text it will treat any input as text, even if it
is numeric or starting with a "=".
Is that really true? I've not been able to confirm that.
Anyway, I've also not been able to replicate the original problem which is
showing the formula rather than the result. Double check it is not something
simple like there being a space before the "=".
I was asked this question once a day for four years as a tech on a help
desk that supported M$ Office.
The cheap way to replicate:
Click a column heading
Format > Cells...
On Numbers tab, select Text as Category
Click OK.
Now type a formula and hit enter.
How did it REALLY get to be text? Spreadsheet apps are friendly and like
to automagically format cells with text as text. Or, some where along
the way, the column was formatted as text manually :)
WalterAM
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
