LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (November 2008, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Mon, 17 Nov 2008 15:59:34 -0800
Reply-To:   "Anderson, James" <James.Anderson@UCSF.EDU>
Sender:   "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:   "Anderson, James" <James.Anderson@UCSF.EDU>
Subject:   Libname excel named range report formatting woes
Content-Type:   text/plain; charset=us-ascii

I'm creating reports using libname excel and writing to a named range. I have preformatted my columns in excel. I have date columns, time columns and others. It looks like the first missing value causes all subsequent values in a column to use a different/wrong format. For example, the time columns start using a date format, the date columns start using a 4-digit year instead of 2-digit year.

Anyone have experience with this and know of a work-around?

Thanks,

Jim Anderson

UCSF

Back to: Top of message | Previous page | Main SAS-L page
listserv.uga.edu
Enterprise Information Technology Services
The University of Georgia
listhelp@uga.edu