Some date &/or Times will not format

  • Thread starter Thread starter Nascarfan88
  • Start date Start date
N

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,
 
Nascarfan88 said:
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,
Click to expand...

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