This worked perfectly!!!

"Rick Rothstein (MVP - VB)" wrote:

If you want to go the formula route as Bob suggested, here is a slightly
shorter alternative for you to consider...

=--TEXT(H1,"0000-00-00")

Rick


"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