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
In B1 enter:
and copy down. Then format column B as you wish.