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.