convert mm/dd/yyyy to m/d/yyyy

by mark   Last Updated November 14, 2017 18:01 PM

I am trying to convert 05/01/2017 to 5/1/2017 by using the format custom text field on excel but the date won't change.

I have a whole set of dates in Column A but will need to transform it as it is in Colum B, however, the formating the fields won't work

     A            B (Result)
10/15/2017      10/15/2017
05/01/2017      5/1/2017
05/15/2017      5/15/2017


Answers 1


In B1 enter:

=DATE(RIGHT(A1,4),LEFT(A1,2),MID(A1,4,2))

and copy down. Then format column B as you wish.

enter image description here

Gary's Student
Gary's Student
November 14, 2017 17:55 PM

Related Questions


Excel 2016 - Any suggestions on functions?

Updated November 10, 2017 00:01 AM