Hello everyone,

I need assistance with the formula, to also include time I have the date
converting properly, just need the time as well, for example:

Column A Converted

11022004 16:21 11/02/2004

Formula used TO CONVERT: =DATE(MID(A1,5,4),LEFT(A1,2),MID(A1,3,2))

Thanks for any help