Convert YYYYMMDD HH:MM:SS to MM/DD/YY HH:MM:SS

[herbie226]

Hello,

I have the following cell value.

20140203 16:36:47

I want to convert this to MM/DD/YY HH:MM:SS format.

Thanks

[Pete_UK]

Assuming that is in cell A1, put this in B1:

=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2)) + TIMEVALUE(RIGHT(A1,8))

Format that cell in the style that you prefer.

Hope this helps.

Pete

[herbie226]

Perfect!

Thank you