We use some software for scheduling class rooms and it has an export to excel
function that saves the database information into an .xls file. When you
open the file two particular fields are formatted incorrectly and not easily
fixed. One field called the general education code is entered as 2a but
converts to 2:00:00 and thus becomes a time the other a credit hour field
entered 01-15 converts to a date of 1/15/2006 and ways to fix this that any
of you can think of? Thanks in advance!