Format row 5 to date dd/mm/yyyy

[Andy15]

HI Guys,

I have found the following code on this site which formats a column to a date, please can anyone help me change it to format row 5

[COLOR=#333333]Sub FixDates()[/COLOR]   Columns("A").TextToColumns
   Range("A1", Cells(Rows.Count, "A").End(xlUp)).NumberFormat = "dd/mm/yyyy" [COLOR=#333333] End Sub[/COLOR]

Thanks

 

[footoo]

Turn on the macro recorder
Select row 5
Format as date
Turn off the macro recorder