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.
 
Try:

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

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

HTH
 
Thanks for the info - but it still gives me #VALUE error. I just dont
understand.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

dd/mm/yy if i change to some other format 2
Weird date format problem 2
Preserving date format 1
Date format - India/USA 7
Count Between dates 11
Count Dates between Dates exclude Text 3
Formatting Dates from Text to Numbers 2
Weekend dates conditional format 3

Back
Top