I need help to edit the current code or create a new code to convert numbers in 6 digit format into dates. Format is DDMMYY.
The current code I use as shown below crops up with run time error 13, mismatch error.
The problem is on the line "sDate = Format(target.Value, "000000")"
Please help out. Thanks.
Please Login or Register to view this content.