I have 20061030 in a cell that is formatted as general. How do I change this
into date format like 10/30/2006? If I format cell and select date then it
gives me #############.