I want to convert a date/time field to a text field so that I can import the
XLS file into a table in Access. This is because I want to have my time
field in the Access DB sometimes store an actual text (like "Lunch") rather
than a time. If I force the first few records to have some text in the time
field, then Access imports the time data like "1/1/1900"

I want to end up with all text in the time field, not a date/time value. Is
there a Paste Special or some other way to get this info into text?