So it's obviously not a date in Excel's eyes, so you'll need to convert the
text into a date..
--
David Biddulph

"Rik385" wrote in message
...
Peo

Unfortunately on Office 2007 and the data that was presented the obvious
mmm
yy didn't work nor did =INT(A2) - curious I know, but nothing is ever
simple,
but it keeps us on our toes.

Rik

"Peo Sjoblom" wrote:

Or just custom format A2 as mmm yy.

If you really want to separate the date you can also use

=INT(A2)






--


Regards,


Peo Sjoblom


"Rik385" wrote in message
...
I realise that this thread is old but I have just come across a similar
problem.

Our own reporting system throws out time and date stamped data and when
pasted in to excel I was having dificulty converting 2007-10-18
10:18:58
into Oct 07. Suggest anyone with similar problems tries =TEXT(A2,"mmm
yy")
extremely simple but hard to find.

If this does not work straight away convert the cell to columns and
then
concatenate the date elements (ignoring the time elements), then try
teh
above formula.

Hope this helps someone

"JT" wrote:

I need to be able to separate the Date and Time from thousands of
entries
that are list as follows:

2/6/2005 2:36:45 PM

If the above is in the same cell, how can I get 2/6/2005 separated out
into
its own cell?

Thank you.