Hi

Take a look at Chip Pearson's site
http://www.cpearson.com/Excel/DateTimeEntry.htm

Regards
Roger Govier

SJT wrote:
I would like to create a format in a cell that allows the number I enter to
be converted into a date in this format "MM/DD/YYYY". However, I would like
to be able to enter the numbers w/o having to use the "/" as a separator btw.
the month and day and the day and year. For example, if I enter the April
29, 2009 as "042909" in a cell, I would like the cell format to convert that
to "04/29/09" instead of "6/23/17" which is what it does now. Thank you in
advance for your assistance.