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.
this code does not modify the date. It still shows jun-21
Any help is welcome, thank you !
Patrick.
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.
VBA Code:
Range("A:A").NumberFormat = "dd/mm/yyyy hh:mm"
Range("B:B").NumberFormat = "mmm/yy"
Any help is welcome, thank you !
Patrick.