Convert mm/dd/yyyy to YYYYMMDD in excel

roosterup
roosterup used Ask the Experts™
on
I need to convert dates stored in this formant, "mm/dd/yyyy" to "YYYYMMDD" in excel.  No slashes in the converted date.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Director, Practice Manager and Computing Consultant
Awarded 2014
Top Expert 2014
Commented:
Right-hand click on the cell and select "Format cells..."

Go to Custom and type in yyyymmdd.

Press OK.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial