and if neither of the two previous replies work, try this on a copy in
case the date format is not the same as yours for instance
if there is any question on interpretation that the date is mm/dd/yy or dd/mm/yy

Try the TrimALL macro
http://www.mvps.org/dmcritchie/excel/join.htm#trimall

BTW, you can of course override the formatting so can't tell for sure
unless you test with ISTEXT or ISNUMBER, but if the date is
left aligned you would expect that it is text and not a number, and if
it is right aligned that it is a number.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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.