Try this:

Select the cell in question
Goto the menu DataText to columns
Click Next twice
In Step 3 of the wizard under Column data format...
Select DateYMD
Click Finish

--
Biff
Microsoft Excel MVP


"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