excel timestamp issue

[nikhilboorla]

I have a numbers like 20160715082219000000000 and i want to convert into timestamp like 2016-07-15 08:22:19 and delete that remaining 0's.Please suggest how to do this conversion?

[compose]

if your data is in cell A3, you can type in this formula in B3 and copy it down to other cells

=MID(A3,1,4)&"-"&MID(A3,5,2)&"-"&MID(A3,7,2)&" "&MID(A3,9,2)&":"&MID(A3,11,2)&":"&MID(A3,13,2)

[khabardar]

itt

[krishnote3]

Good ..

58 minutes ago, compose said:

if your data is in cell A3, you can type in this formula in B3 and copy it down to other cells

=MID(A3,1,4)&"-"&MID(A3,5,2)&"-"&MID(A3,7,2)&" "&MID(A3,9,2)&":"&MID(A3,11,2)&":"&MID(A3,13,2)

Good job