VBA date in local format

[opislak]

Hello all,

As a European, my keyboard layout is set by default to show dates with '-' as in 11-06-2021 or jun-21
I would like to modify the '-' by a slash '/', to show 11/06/2021 or jun/21
The code I use doesn't work.

            Range("A:A").NumberFormat = "dd/mm/yyyy  hh:mm"
            Range("B:B").NumberFormat = "mmm/yy"

this code does not modify the date. It still shows jun-21
Any help is welcome, thank you !
Patrick.

 

[opislak]

Insteresting, I see "Jun/21" on the DropBox site, even before I download the file.
So we are seeing different things. So it appears I cannot replicate your issue.

Dear Joe4,
No problem. Thank you very much for trying and searching. Much obliged.
Patrick.

 

[opislak]

​

Opislak, as so obviously the slash is not used in your local date settings so the VBA format must be

"mmm""/""yy"

​

Dear Marc L,
That works !!! Great, so easy... Thank you very much !!
Patrick.