Excel Function to change date in "2011-02-10 19:18:11" format to "10/02/2011 19:18:11" format
=CONCATENATE(MID(N2,SEARCH("-",N2)+4,2),"/",MID(N2,SEARCH("-",N2)+1,2),"/",MID(N2,SEARCH("-",N2)-4,4)," ",MID(N2,SEARCH(":",N2)-2,2),":",MID(N2,SEARCH(":",N2)+1,2),":",
,MID(N2,SEARCH(":",N2)+4,2))
No comments:
Post a Comment