correction
=left(b3,2)&"/"mid(B3,2,2)&"/"&right(b3,2)

adjust cell address to suit.

regards
FSt1


"FSt1" wrote:

hi
since the year comes first in your example, it might require some flipping
around. you might try this in a helper(blank) column added next to the
problems dates. then insert this fomula in the top cell and copy down the
helper column.
=MID(B3,3,2)&"/"&RIGHT(B3,2)&"/"&LEFT(B3,2)
you could then copy the helper column and paste special values over the
problem dates and delete the helper column.

regards
FSt1

"John Weaver" wrote:

A former employee recorded all dates as 090917 (yymmdd, September 17, 2009)
as text format.

How do I convert this format to 09/17/09, mm/dd/yy format?