Date Format Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You have invisible text characters in your import, it might be extra spaces
or html line feed

Go here, install the macro (on the same site there are instructions on how
to install macros) then select the imported "text" and run the macro, most
likely you need to format the values as date after they have been converted.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall
 
Back
Top