Text output of a date/time field

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?

On Fri, 4 Nov 2005 18:16:17 -0800, "Bob Richardson" <bobr at whidbey dot com>
wrote:

>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

Perfect. Thanks Ron.

"Ron Rosenfeld" <ronrosenfeld@nospam.org> wrote in message
news:kc7om1t8k254uj9tj5dvjs7bm8aiahh4d6@4ax.com...
> On Fri, 4 Nov 2005 18:16:17 -0800, "Bob Richardson" <bobr at whidbey dot
> com>
> wrote:
>
>>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