At 01:21 AM 8/28/2007, David wrote: >On Tue, 28 Aug 2007, Robert A LaBudde wrote: > >>If you format the column as "Text", you won't have this problem. By >>leaving the cells as "General", you leave it up to Excel to guess at >>the correct interpretation. > >Not true actually. I had converted the column to Text because I saw >the interpretation as a date in the .xls file. I saved the .csv file >*after* the column had been converted to Text. Looking at the .csv >file in a text editor, the entry is correct. ><snip>
You need to convert the column to Text before you enter the data. This tells Excel the presumption to use. Converting to Text after you enter the values has no effect on previously entered values. I've tested this using Excel 2000. ================================================================ Robert A. LaBudde, PhD, PAS, Dpl. ACAFS e-mail: [EMAIL PROTECTED] Least Cost Formulations, Ltd. URL: http://lcfltd.com/ 824 Timberlake Drive Tel: 757-467-0954 Virginia Beach, VA 23464-3239 Fax: 757-467-2947 "Vere scire est per causas scire" ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
