Date: Tue, 12 Dec 2006 10:17:24 -0800
Reply-To: David Fickbohm <davefickbohm@YAHOO.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: David Fickbohm <davefickbohm@YAHOO.COM>
Subject: how to keep date formatting after exporting
Content-Type: text/plain; charset=ascii
I have a sas file. The file contains a rundate. The rundate is formatted YYYY-MM-DD. When I export the file the rundate formatting converts to MM/DD/YYYY.
If I look at the file in notepad the rundate is YYYY-MM-DD. So excel is reformatting the rundate.
Does anyone have an idea how to approach this situation ? Should I send this question to an Excel group ?
Your thoughts and ideas will be appreciated.
Use Technology to the Fullest
1250 45th st suite 200
Emeryville, CA, 94608
510 594 4151 voice