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 :
![]()
Please Login or Register to view this content.
I thought the result would be:
The other thing is when the manual custom format process is "dd-mm-yyyy",![]()
Please Login or Register to view this content.
the resulting code is :
Maybe someone can explain it to me why the result is like that ?![]()
Please Login or Register to view this content.
Thank you in advanced.
My computer Short Date setting is : dd-MMM-yy
Bookmarks