VBA to convert date value to another format of date

[shiva_reshs]

Hi,

I have column with below date value in it.

Please Login or Register  to view this content.

I need VBA which will convert the value to 6/18/2014 1:44:13 PM in cell.

Please assist.

Thanks,
Shiva

[shiva_reshs]

Please Login or Register  to view this content.

I tried this one, But it changes the date to 6/18/2014 12:00:00 AM

[AB33]

Shiva,
I have not looked at your code, but this gives the right format. I have tried it on range("A17") and converted in B17.

Please Login or Register  to view this content.

[shiva_reshs]

It works well..But how to make it run on every cell?

Thanks,
Shiva

[shiva_reshs]

Like Entire A column to B column?

[AB33]

Where is the data? Which column? If the data are in Jun-18-2014 01:44:13 PM format, you just need to
loop through each cell and convert them in proper format.

[shiva_reshs]

Column A

Jun-18-2014 04:24:57 PM
Jun-10-2014 06:58:33 AM
Jun-06-2014 10:20:47 AM
Jul-02-2014 12:19:19 PM
Jul-01-2014 10:49:19 AM
Jun-10-2014 02:38:33 AM
Jun-18-2014 12:10:32 PM
Jun-20-2014 12:48:55 PM
Jun-23-2014 12:07:41 PM
Jun-27-2014 12:13:53 PM
Jun-09-2014 04:30:22 PM
Jun-11-2014 03:11:08 PM

[AB33]

If it is column A ONLY, remove the second line.

Please Login or Register  to view this content.

[shiva_reshs]

Thanks for the code AB. Works perfect.

Thanks,
Shiva

[shiva_reshs]

Thanks a lot.. Both code works perfect.

Note: Please ignore.. Accidental type through Android App.