ExcelBanter - changing date format

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - changing date format (https://www.excelbanter.com/excel-programming/411236-changing-date-format.html)

Jock

changing date format

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,
--
Traa Dy Liooar

Jock

Sam Wilson

changing date format

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

Sam

"Jock" wrote:

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,
--
Traa Dy Liooar

Jock

Jock

changing date format

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

Jock

"Sam Wilson" wrote:

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

Sam

"Jock" wrote:

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,
--
Traa Dy Liooar

Jock

All times are GMT +1. The time now is 11:37 AM.