Recorded macro for date format is different with the recording process

[karmapala]

I macro record when I do this manually :
select a cell with a date value
custom format it to "d/mm/yyyy"
stop the macro.

The resulting code is :

Selection.NumberFormat = "d\/mm\/yyyy"

I thought the result would be:

Selection.NumberFormat = "d/mm/yyyy"

The other thing is when the manual custom format process is "dd-mm-yyyy",
the resulting code is :

Selection.NumberFormat = "d/mm/yyyy"

Maybe someone can explain it to me why the result is like that ?
Thank you in advanced.

My computer Short Date setting is : dd-MMM-yy

[Marc L]

Maybe 'cause of the Windows Regional settings …

[karmapala]

Thanks for the answer, Marc.

This made me think if for example I'm helping someone where the code need a date format,
then the result seen in my computer may be different than in his computer .

Because within my computer :

Selection.NumberFormat = "d/mm/yyyy"

or

Selection.NumberFormat = "d-mm-yyyy"

gives the same display in the cell, which is :
25-12-2020

I wonder if I write :

Selection.NumberFormat = "d\/mm\/yyyy"

No matter is the regional setting, the result in the cell will be:
25/12/2020

Thanks once again, Marc

[Vraag en antwoord]

It is therefore a very good date to test with.

[Marc L]

karmapala see one month ago in this thread …

[karmapala]

Marc,

Wow, I never thought that the same thing is also happen with nankw83 .
I'm sorry that I didn't do search first in this forum.

Yes, you are right then it's because my Windows Regional Setting,
as I have in my computer is with minus sign : dd-MMM-yy.

But still I think that it can leads to a confusion, if I write :

Selection.NumberFormat = "d/mm/yyyy"

although seeing in my computer has a correct display ---> 25/12/2020 (after change the Windows Regional Setting),
but if the other computer's Windows Regional Setting is dd-MMM-yy, then the display is 25-12-2020.

Thank you once again for sparing your time to search the one month ago link, Marc.

[Marc L]

You're welcome ! One month ago I had never met this case …