Because Excel stores dates as the number of days since 1/1/01, the date is actually stored as "37780" or some such number, so if you just change the format to text, you get that slightly unuseable number (as you may already know). The only way I know to accomplish the task is to format the cell first as text, then key in the date as you want it to show.
Sawedoff