rearranging text in a cell

P

peacekeeper

Would someone please tell me how to rearrange the text
entries in a column of cells that indicates the date when
a certain lab test was performed. For example, the cell
currently shows:

"6219805" which corresponded to a mddyy##

and I want it to read instead as:

"1998062105"

That is, yyyymmdd##

Thanx for your help!
 
Top