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]
