I have some data I'm pulling from a DB thru SQL. The dates and times are coming out as just 6 digit numbers.

Here are 2 examples.

Number 220724 which translates to 07-24-22

Number 225959 which translates to 22:59:59

I want to convert these in excel to read as the proper date.