For example, if you value is in A1, then in a helper cell put:

=MID(A1,7,2) & "/" & RIGHT(A1,2) & "/" & LEFT(A1,2) & MID(A1,4,2)
--
Gary''s Student


"jtmousel" wrote:

I have imported a text report into Excel. For some reason the date
string on the text file reads as 20/05/0728. Is there a quick way to
reformat the string so it reads 7/28/2005 or even 2005/07/28, for that
matter. I really don't want to manually edit 300+ lines! Thanks.