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