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.
Rod
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
