VBA can't set date format on column

Question

i'm trying to change column format from "Custom" to "Date" by

Columns("F:F").Select
Selection.NumberFormat = "Date"

but it set's F column's format just to another Custom, and for example

05 / 16

becomes to

1at2016

Can you please help me?

Answer 1

Selection.NumberFormat = "mm/dd"

that should do the trick.