On Mon, 2005-04-25 at 15:37 -0500, Rod Engelsman wrote: > G. Roderick Singleton wrote: > > On Mon, 2005-04-25 at 21:40 +0200, JS wrote: > > > >>"David Chapman" <[EMAIL PROTECTED]> skrev i en meddelelse > >>news:[EMAIL PROTECTED] > >>If this is a string - just put a ' before it. With '8-9 entered, OOo > >>Calc will make > >>no inference to the format of the data - and treat it as a string. > >> > >> > >>But I don't want a ' before all my numbers. Is there someway do disable OOo > >>Calc? > > > > > > I would select the column and set the format for that column to text. > > Likewise for a row. > > Be advised that once you do that you can no longer enter a formula into > any of those cells without first setting the format back to General. > Like to drive me nuts until I figured that out. >
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. -- PLEASE KEEP MESSAGES ON THE LIST. Documentation Co-Lead http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
