Date Format Problem

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.
 
P

Peo Sjoblom

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
 

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
Date format - India/USA 7
Preserving date format 1
Pivot Table Date Format 2
date format 1
How to set the cell for date? 7
Pivot Table date format 1

Top