Quote Originally Posted by GTO
Hi there,

At least as posed, select all the cells from row 2 and downward in Col D, right-click and choose format cells... Then select the number tab and custom in the category box. If the format you want is not listed, build it there.
That's good idea. I can record Marco using your suggestion. But, I don't know why my system was not able to format Date.