If they are real dates (test one by =yourcell*1 in another cell) then just
highlight the cells and change the format.
formatcellsdate

--
Don Guillett
SalesAid Software

"Andrew" wrote in message
...
I have a large Excel sheets with a list of dates. The problem is they are
listed with periods separating the components. Is there a quicker way to
convert them into the standard format with slashes than manually entering
them myself?