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:


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