Date data not viewed as Date?
 

I have tried some previous posts for other questions somewhat relating to my
situation and they don't work.
Is there something uniquely wrong with my data?

A customer has imported some data into Excel.
They have a column that shows data
that looks like a date format: Nov 23 2005 6:47 AM
However, the format appears to be General. When they try to format this
column to Date Formats, the data does not accept the format change to dates.
It just doesn't act like normal data when the Date formats are applied. The
formatting list also shows an asterick (*) now.

Any suggestions would be greatly appreciated!
Jugglertwo

Date data not viewed as Date?
 

Is this perhaps stored as text? General format would not show a date like
this, it would look like 39044.28264. An easy way to fix these, if you've
captured the format correctly, would be to select the range of nonconforming
dates, search for " 200" (without the quotes) and replace it with ", 200".
The comma is enough formatting for Excel to recognize the cell's content as
a date rather than gibberish text.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jugglertwo" wrote in message
...
I have tried some previous posts for other questions somewhat relating to
my
situation and they don't work.
Is there something uniquely wrong with my data?

A customer has imported some data into Excel.
They have a column that shows data
that looks like a date format: Nov 23 2005 6:47 AM
However, the format appears to be General. When they try to format this
column to Date Formats, the data does not accept the format change to
dates.
It just doesn't act like normal data when the Date formats are applied.
The
formatting list also shows an asterick (*) now.

Any suggestions would be greatly appreciated!
Jugglertwo