I'm trying to format a date using 

```
   Dim dt As Range
For Each dt In Range("A1:A1000")
    dt.NumberFormat = "m/d/yyyy"
Next dt

```

Some dates doesn't change

but when I click twice the dates receive the format, 
sometimes it happens with values too, what's going on ?

[![enter image description here](https://i.stack.imgur.com/XEURh.jpg)](https://i.stack.imgur.com/XEURh.jpg)