0

I have a worksheet that has custom dates e.g.

August 26th 2015

and I would like to convert this to

8/26/15

Is this possible ?

1
0

Go to Data tab and click on Text to columns, choose fixed width and click next two times, and in column data format, choose date and select MDY, and click finish. If your date is in A1, they will now be in separate columns- A1 will hold August, B1 will hold 26th and C1 will hold 2015. In D1 type the following:

=MONTH(DATEVALUE(A1&"1"))&"/"&LEFT(B1,LEN(B1)-2)&"/"&RIGHT(C1,LEN(C1)-2)

output:

 8/26/15

Or you can download a 60days trial excel tools called kutools

Hope this may help you.

1
  • 1
    @AlanBreck If this fully answers your question, please mark it as accepted (green check mark to the left)
    – nixda
    Aug 29 '15 at 23:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.