1.In Excel I would like to enter a number string say 01011998122320 and convert it into a date time format i.e.
01/01/1998 12:23:20 i.e dd/mm/yyyy hh:mm:ss
where incorrect or invalid values would return error message and correct values return the excel entry in date/time format
2.if date and...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.