Or =--TEXT(A1,"0000\-00\-00 00\:00\:00"), and format the cell to suit.
--
David Biddulph

"Gary''s Student" wrote in message
...
Say A1 contains:
20081218133512
then enter:
=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))+TIME(MID (A1,9,2),MID(A1,11,2),RIGHT(A1,2))

to display 12/18/2008 13:35:12

to get this use Format Cells... Number Custom m/dd/yyyy hh:mm:ss
--
Gary''s Student - gsnu200821


"Toria" wrote:

Hello,

I have a number that looks like this: 2.01E+13. This is formatted as
scientific in Format Cells. This actual number is 20081100000000. This
needs
to be in a date/time format, but Format Cells just gives ##############.