Andrew Douglas Pitonyak wrote:
I thought that you could turn that off... (that is when Calc converts an entered number into a date)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.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?
If I format the column to text before entry, then 10.13.08 is not converted to a date.
--
Bill Drescher
william {at} TechServSys {dot} com
