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