Apply the below formula

=TEXT(TEXT(A1,"00000000"),"00-00-0000")+0
and format that to any date format

If this post helps click Yes
---------------
Jacob Skaria


"Cindy" wrote:

Using Excel 2007. Inherited a spreadsheet with a column were the numbers are
7312008, which needs to be 07/31/2008. Current format shows "general". When
I choose format cell and change to date, I get ###### with an error that
shows times are negative. Making the column wider does no good, I just get
more ###'s.