CODEWITHSUNDEEP
exceldatedatetime
Jitesh Vacheta
Jitesh Vacheta

Reputation: 85

Converting MM:DD:YYYY hh:mm:ss to DD:MM:YYYY hh:mm:ss in excel

I'm trying to convert the timestamp data in Microsoft excel where the timestamp is coming as
MM:DD:YYYY hh:mm:ss (12/25/2016 12:00:55 AM).
this Formet doesnt support in excel and i wanted to change it to
DD:MM:YYYY hh:mm:ss (25/12/2016 12:00:55 AM)
i have seached so many times but all i get is DD:MM:YYYY to MM:DD:YYYY which is not the case.

Upvotes: 0

Views: 7353

Answers (1)

Jason Stallard
Jason Stallard

Reputation: 348

Either add a column with =MID(B2,4,3) & LEFT(B2,2) & RIGHT(B2,17) where B2 is replaced with your date value cell reference (The formula only works if all dates are in that 22 character format you used as an example).

or

write a macro to amend the values in that column.

Upvotes: 2

Related Questions