In Excel 2007 I need to have the date read as follows in several columns and
it keeps appearing as a five digit number instead!! Pls help!

Example: I need Jan 1 to read 01/01 in the column

Thanks!