I have a cell with Q107. This there a function that would change it into 1/1/07. I can create a big case or if statement, but that seems silly.

Thanks for the help,

Chris