The following has happened briefly from time to time,
and I've never followed up on it, just worked around it.
A couple days ago, working on a new sheet in a new .ODS file,
has happened again, and has persisted.
I have about half a dozen columns, all specified as "Text" ("@").
Into column "A", I put the values I have at hand --
strings of digits separated by various kinds of punctuation.
In column "D" I have put a formulat involving a lot of SUBSTITUTE functions
that removes all of the punctuation.
As intended, the column displays the strings from column "A"
with all the punctuation stripped out.
However, in Column "H" I entered a formula to select just a substring
(using the MID function);
instead of displaying the substring, it displays the *formula itself*.
In another column, I entered a different formula to select a different substring
(using the RIGHT function); again,
instead of displaying the substring, it displays the *formula itself*.
I've checked and checked again, and all the cells in all the columns
appear to have the same format, including "Number", Font, Font Effects,
Alignment, Borders, Background, and Cell Protection.
Anyone have any idea what might be the problem,
or something in particular I should check for?
Thanks.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
