Text output of a date/time field

[Bob Richardson]

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?

 

[Ron Rosenfeld]

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?

Look at the TEXT worksheet function. It will return a text string, formatted
as you like.


--ron

 

[Bob Richardson]

Perfect. Thanks Ron.

Look at the TEXT worksheet function. It will return a text string,
formatted
as you like.


--ron