changing date format

[Jock]

How can I change this 04.08.08
to this
04 Aug 08 ?
There are hundreds of rows with dates in this type of date format.
Is there a way using VBA to 'ripple through' these and change them to the
desired format without doing them all manually?

Thanks,

 

[Sam Wilson]

Select the whole column and do a find & replace (ctrl + H) and replace . with /

Sam

 

[Jock]

That'll do. Thanks Sam
--
Traa Dy Liooar

Jock

Select the whole column and do a find & replace (ctrl + H) and replace . with /

Sam