M
Mangesh Yadav
If the excel recognises your entry above as a date, you simply have to go to
Format > Cells > custom and enter the format:
mm/dd/yyyy
whereas, if excel is treating your entry above as text, and supposing your
entry is in cell A1, then use the following formula:
=DATEVALUE(RIGHT(A1,(LEN(A1)-FIND(" ",A1))))
and then format as mentioned above.
Mangesh
PS: People here appreciate a message body instead of a subject only.
Format > Cells > custom and enter the format:
mm/dd/yyyy
whereas, if excel is treating your entry above as text, and supposing your
entry is in cell A1, then use the following formula:
=DATEVALUE(RIGHT(A1,(LEN(A1)-FIND(" ",A1))))
and then format as mentioned above.
Mangesh
PS: People here appreciate a message body instead of a subject only.