How do I convert time in excel from 2017-04-03T12:16:27.961Z format to a DD-MMM-YY format -

how convert time in excel 2017-04-03t12:16:27.961z format dd-mmm-yy format

i trying convert data ca agile excel can depict changes on time. right forced manually change format instead of using automated way.

use formula, format wish:

=--substitute(substitute(a1,"t"," "),"z","")