=DATE(LEFT(H1,4),MID(H1,5,2),RIGHT(H1,2))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Newbee" wrote in message
...
I have a spreadsheet with 20071123 is in number format. I am trying to
covert it so that excel will see those numbers as a date. It is not text
but
in number format. How do I change this to make it read 11/23/2007