What kind of number is it? and what do you use it for? Calc is converting your number to a date becuase it sees 3 diferent numbers separated by a dot, and it asumes it must be something like a date because a date has this kind of format MM.DD.AA and your number looks like a date OCT-13-2008, I think a human being could interpret that number as a date also, but anyway, you could use the single cuot >> ' << to convert the number to a string.
2008/10/21 Andrew Douglas Pitonyak <[EMAIL PROTECTED]> > > bill wrote: > >> Andrew Douglas Pitonyak wrote: >> >>> I thought that you could turn that off... (that is when Calc converts an >>> entered number into a date) >>> >>> All that I could find, however, was that you can precede the number with >>> a single quote so that it is entered as text. >>> >>> very sad... If it is indeed a number, what happens if you then change the >>> format from date back to a normal number? >>> >>> I typed 10.13.08 and it was automagically converted to 10/13/08. When I >> changed the format from number/general to number/-1234 my now date was >> converted to 39734. >> >> If I format the column to text before entry, then 10.13.08 is not >> converted to a date. >> > A value such as 10.13.08, you want OOo to convert to a text entry. precede > your entry with a single quote, and then enter 10.13.08 and it will not > attempt to convert the entry to a date. This is the "official" way to avoid > the problem in a Calc document. You can not argue that you do not want the > entry as text, because, well, it is not a valid number. It is unfortunately > that you can not tell OOo to NEVER recognize an entry as a date, even when a > valid date format is used to enter data (especially if it is not entered in > the default locale). If it converted a number such as 101308, that would be > different. > > -- > Andrew Pitonyak > My Macro Document: http://www.pitonyak.org/AndrewMacro.odt > My Book: http://www.hentzenwerke.com/catalog/oome.htm > Info: http://www.pitonyak.org/oo.php > See Also: http://documentation.openoffice.org/HOW_TO/index.html > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- --------------------------------------------------- Carlos Joel Delgado Pizarro Mosoq Kallpa - Linux Users Group IN - UNSAAC - CUSCO - PERU Linux User Registered # 460895 http://carlosj.perulinux.net
