Changing Text to Time in Excel

I have a large database that is sent to me for anaysis on a regular basis.
My problem is with times. They are sent to me in the for 0122 as text. I
need help converting them to a time that excel can deal with (without
manually fixing them, as there's about 100,000 pieces of data that need to be
updated).

Thanks your your help.

add a helper column

=TIME(LEFT(A2,2),Right(A2,2),0)

and copy down

--
HTH

Bob Phillips

"Chip193" <[email protected]> wrote in message
news:[email protected]...
> I have a large database that is sent to me for anaysis on a regular basis.
> My problem is with times. They are sent to me in the for 0122 as text. I
> need help converting them to a time that excel can deal with (without
> manually fixing them, as there's about 100,000 pieces of data that need to
be
> updated).
>
> Thanks your your help.
>