< Recap: Why will my date/time cell "01/12/06 15:38:17" not format to lets
say "Thursday, January 12, 2006?

Because it is text, not a date (not for Excel).
Importing as txt gives you a chance to get the right data type (which is not
the same as the right format).
An alternative is to change it to a date afterwards with the DATEVALUE()
function. Not all date text formats are recognized by this function,
however. Maybe you have to (temporarily) change your Windows settings in the
Control Panel and/or strip time characters from the date.

--
Kind regards,

Niek Otten

"Jamie Kelly" <Jamie wrote in message
...
I have collected about 1000 points of data from the HyperTerminal program
and
saved the data as two file formats one being .txt and the othet .csv.
When I
load the .csv file I am not taken through the wizard which is okay. When
I
load the .txt file I am. Anyways, my question is.. why will my cells not
format? Currently this is what the cell looks like that i want to format
"01/12/06 15:38:17" and there is one for every second for about 1000
seconds.
Excel reads these cells as general cells, I am curious why I can not
change
them to a date format. The reason I want them to be a date format is
because
I will be graphing this informat and it needs to be acurate as I am
writing a
manual on how to setup a "Internal Data Logger for a portable D.O.
analyzer"
and how to send the information to a computer. Any help?

Recap: Why will my date/time cell "01/12/06 15:38:17" not format to lets
say
"Thursday, January 12, 2006?

I do believe the cells are locked.. but when I unlock them.. still nothing
happens.