I have a worksheet containing a column of dates. Some are in the format 102103 - i.e. month, day, year without any separation between them, and some are 10/21/2003 - i.e. separated by forward slashes. I want to format all of the cells in this column to contain the forward slashes as in the second example. Is there any simple way for me to do this? If not, and I have to write some VBA code, how do I loop through the cells of a range that has been selected by the user and format each one?