how to change the yyyy/mm/dd hh.mm.ss to dd/mm/yyyyy

[baskar5353]

hi

i having one workbook some columns i'm having cells like yyyy/mm/dd hh.mm.ss want to change into dd/mm/yyyy
how to do it in VBA

Regards,
Baskar P

 

[JoeMo]

hi

i having one workbook some columns i'm having cells like yyyy/mm/dd hh.mm.ss want to change into dd/mm/yyyy
how to do it in VBA

Regards,
Baskar P

Select the cells you want to change, then run this macro.

Sub ConvertFormat()
'Select cells to convert .Then run macro
Dim c As Range
Application.ScreenUpdating = False
For Each c In Selection
       If IsDate(c.Value) Then c.Value = Int(c.Value)
Next c
Selection.NumberFormat = "dd/mm/yyyy"
Application.ScreenUpdating = True
End Sub