RE: [S] S: Importing Excel files

Rob Balshaw (balshaw@synectics.bc.ca)
Mon, 23 Nov 1998 09:12:36 -0800


When importing from Excel using the old fashioned cut and paste
method...

The first date in a column of dates is usually "read" as a numeric
value instead of as a date value, and it seems to be the value
of the "day" that is entered. I tend to use the "23-Nov-98" format
in Excel and in S-PLUS and "23", but I haven't checked this with
other formats. It only happens for the first observation; the
second and subsequent date values are treated correctly as dates.

Now that I've noticed this, I cut and paste the first observation over
again, and that seems to do the trick.

Has anyone else noticed this? Even better, does anyone know a way to
prevent this from happening?

Admittedly, a pretty minor glitch, but it was one of those things that
took me a while to diagnose the first time it came up.

Thanks for any suggestions (or pointer to the manuals(?)),

Rob

--
Rob Balshaw, PhD                            Synectics Health Corporation
balshaw@synectics.bc.ca                   University of British Columbia

----------------------------------------------------------------------- This message was distributed by s-news@wubios.wustl.edu. To unsubscribe send e-mail to s-news-request@wubios.wustl.edu with the BODY of the message: unsubscribe s-news