Change format of each cell in a column

Hi,
first - letting you know that I am an IT person and had no idea how VBA works until today.
So I need to change each cell format from 8/25/2015, etc (those are dates) to 08-25-2015
Basically need to replace "/" with "-".
I found this code and it works well but only for selected cell.

With ActiveCell
.NumberFormat = "@"
ActiveCell.Value = Format(ActiveCell.Value, "mm") & "-" & Day(ActiveCell.Value) & "-" & "20" & Format(ActiveCell.Value, "yy")
End With

I need to apply this change to the whole Column (column might have different number of rows), so to the end of a column.

Thanks!

Hello,

change the K to the column with the dates

Please Login or Register  to view this content.

Kind regards
Leo

Thanks, Leo. This worked perfectly.
YasserKhalil is also good, but yours works better for my needs.
Thanks again

Nice, can you mark the case as solved ?


Thanks
Leo