On Monday 25 April 2005 04:46 pm, Steve Kopischke wrote: > '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)
I do not recall that behavior on visicalc on my TRS-80. hammer29 > > --------------------------------------------------------- >------------ To unsubscribe, e-mail: > [EMAIL PROTECTED] For additional commands, > e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
