'Rod Engelsman' wrote on 04/25/05 19:36:
G. Roderick Singleton wrote:
True. But the OP didn't like the first answer he got so I made another
suggestion. However, I have not tried to insert formulae when I need
text so have never encountered what you describe.
Fair enough. Those *are* really the only options available.
As for the second part. It only seems to occur if you explicitly set
the format to text. BUT, it has some weird characteristics. I was
trying to do something that involved a lot of text manipulation --
breaking up strings and putting them together using left(), right(),
mid(), and concatenate(). The strings were 0's and 1's, binary
numbers, so to make my life easier (I thought) I just formatted the
whole sheet as text.
Worked fine for entering the strings as constants, but when I tried to
enter a formula, it would just enter the formula as text. So I would
reformat that cell as General and then the formula would take. But the
weird part was that I couldn't *edit* the formula later. If I tried,
it would just enter the formula itself as text. So I had to constantly
reformat cells as General before I could edit a formula. PITA.
Would you call that a bug, or just inconvenient behavior?
FWIW, Excel does the exact same thing, so I didn't pursue it any more.
I've been using spreadsheets since Lotus 1-2-3 1A back in the days of
hammers, chisels and stone tablets. The behavior you describe might be
called inconvenient, but it is also expected. I have seen that sort of
behavior in every version of every spreadsheet application I have used
since late 1983.
oldgnome
(now you know where the "old" comes from, anyway)
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
