Some date &/or Times will not format

[Nascarfan88]

Good afternoon,

I've imported some Date & Time data into excell, but when I try to format
the colums as either date or time, some of the cells will not formatt. I've
been told that sometimes importing data will result in hidden characters that
will prevent formatting. Any way to correct this using a formula or other
means?

ex: 11/27/2009 16:23:00 PM .

Best regards,

 

[VanguardLH]

Good afternoon,

I've imported some Date & Time data into excell, but when I try to format
the colums as either date or time, some of the cells will not formatt. I've
been told that sometimes importing data will result in hidden characters that
will prevent formatting. Any way to correct this using a formula or other
means?

ex: 11/27/2009 16:23:00 PM .

Best regards,

As per the title of this newsgroup, this one discusses Outlook. Excel (one
"l") is discussed in a different newsgroup.