Excel: Converting troublesome date format

Hello: Say I have 2017-02-01T01:33:06Z in cell B31 How I convert 2017-02-01T01:33:06Z into 01/02/17? I tried TEXT(B31,"mm/dd/yy") but Excel is retuning the same date format in B31 Thanks for your help. Regards, Sean

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of April 22, 2017.

For more resources for Microsoft Excel