quickly converting Date stored as text in a specific format to Date

[JokerUSN]

Hi. I have a bunch of data that has a date field in the format yyyymmdd. Is there a way to quickly convert it to mm/dd/yyyy in date format? Currently breaking it down with left/mid/right formulas and then Format(CDate()) but was hoping there might be an easier way. If what I have is it, then that's it. Just thought there might be a more elegant method out there.

Thanks!

 

[NauticalGent]

I am unaware of any other way than what you have already figured out. Best of luck!