Date format macro code

[jaeremata]

Hi Everyone, I need some help in my macro. Currently I have a code that will change the date format to yyyy-mm-dd, but what I want to also happen is to change it on Short date. Here's my attempt:
If you can see on the SS, the highlighted yellow is what is showing on the filter but what I want is on the blue circle. When I used .Value = DateValue its' not working. Is there anyway to change it like on the blue circle on?

Here's my attempt:
With Worksheets("NC")
With .Range("j3:k" & .Cells(.Rows.Count, "G").End(xlUp).Row) 'Fixed

.NumberFormat = "yyyy-mm-dd"
.Font.Size = 11
.Font.Name = "Calibri"
.Font.Color = vbBlack
.Font.Bold = False

 

[Akuini]

How about:

.NumberFormat = "yyyy-mmmm-dd"

 

[jaeremata]

How about:

.NumberFormat = "yyyy-mmmm-dd"

Its already on numberformat, but still, its showing the same on the screen shot i provide.

 

[Akuini]

Your code is .NumberFormat = "yyyy-mm-dd"
Mine is .NumberFormat = "yyyy-mmmm-dd"

 

[jaeremata]

Your code is .NumberFormat = "yyyy-mm-dd"
Mine is .NumberFormat = "yyyy-mmmm-dd"

View attachment 31100

When I do that, it will change the value on the column. What I want to see is the look will be the same on the excel like this, but the filter will give me the option like on your screen shot

 

[Akuini]

What I want to see is the look will be the same on the excel like this, but the filter will give me the option like on your screen shot

Sorry, I don't know how to do that.
Maybe other members have a better idea.

 

[jaeremata]

Sorry, I don't know how to do that.
Maybe other members have a better idea.

It's ok. I got it now. Thank you for your help.

 

[Akuini]

You're welcome, glad you figured it out.