Visit Chip Pearson's site:
http://www.cpearson.com/excel/DateTimeEntry.htm

And you'll find one way.

Jennifer wrote:

I would like to enter a date without having to enter -'s or /'s and have it
display mm/dd/yy. I know how to make this work for phone numbers but can't
seem to find the correct formatting for dates. Thank you.
--
Though daily learning, I LOVE EXCEL!
Jennifer

--

Dave Peterson