Changing a text field into a date

[Barb Henderson]

I have a database whose job number is a date.
The job number is a text field and we would also like to
display it as a medium date.

example job number is 110703 and we would also like to
display it as 11-Jul-03.

Suggestions?

Thanks