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