Try:

=TEXT(DATEVALUE(A1),"MM/DD/YY")

I have A1=1/3/07 as a TEXT field.

HTH

"Gayla" wrote:

I have downloaded data from our time keeping system which has dates in format
of M/D/YR (1/3/07) i would like them in the format of MM/DD/YY (01/03/07). I
have tried date value formula, text to columns and format date options and I
just get value error. I tried converting using error checking but that did
not work either.
Any suggestions.