I am trying to enter a 6 digit number in a cell, leave the number as entered but treat it as a date. For example:

311210 would be displayed as 311210 but treated as the date 12/31/2010 (December 31st, 2010). I have tried using Format Cells but it gives crazy results.