Quote Originally Posted by drmcboy
highlight the cells that have the dates, do a search and replace (Control-H) - replace the dot (.) with a slash (/).
I'll try that