It's all about the answers!

Ask a question

date format in csv export


Prashanth Danda (11) | asked Apr 25 '17, 10:54 a.m.

 Hi Rob Logie,


I am reading the below page where you have provided answer to convert string into an excel time stamp.

You have given formula to convert Apr 24, 2017 5:22 AM into 24/04/2017 05:22.

I need an Excel formula to convert 2017-04-11T10:04:33.632Z into 11/04/2017 10:04

Please can you assist me with the Excel formula?

Thanks a million.


Be the first one to answer this question!


Register or to post your answer.