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?