Hi

That's because Excel stores dates as serial numbers, but displays the
value in whatever format you choose.
To get just the data part out of Date and time, just use
=INT(A1)

--
Regards

Roger Govier


"wayliff" wrote
in message ...

I'm trying to extract the date from a cell using the MID formula and
all
I'm getting is some weird number that does not seem to make sense.
I have tried formatting the target cell but still no change.

Any clues about it? How can I do this?


1/13/2006 12:16:29 AM

=MID(E5,1,9)

38730.011


--
wayliff
------------------------------------------------------------------------
wayliff's Profile:
http://www.excelforum.com/member.php...o&userid=29860
View this thread:
http://www.excelforum.com/showthread...hreadid=501062