Please how do convert this using an Excel macro:

06.01.2014 00:00:00
06.07.2014 00:00:00


TO:

06/01/2014
06/07/2014

Assuming subject cells are selected...

In a standard module:

Option Explicit

Sub ConvertDateTimeToDateOnly()
Dim rng
For Each rng In Selection
rng.Value = DateValue(Replace(rng.Value, ".", "/"))
Next 'rng
End Sub

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion