[R] Excel

Robert A LaBudde ral at lcfltd.com
Tue Aug 28 14:52:36 CEST 2007

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.

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: ral at lcfltd.com
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"

More information about the R-help mailing list