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.