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","") 

enter image description here


Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -