LinkBack URL
About LinkBacks
One of our interns collected some data for me but they entered the dates "2 14 2014". I need to convert these into a usable date format in hurry. Any suggestions?
Convert numbers entered into a date
One of our interns collected some data for me but they entered the dates "2 14 2014". I need to convert these into a usable date format in hurry. Any suggestions?
Add an excel file (without confidential information) and I will take a look at it.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Use the formula
To make the data "look" right.
=SUBSTITUTE(A1," ","/")
Then copy the result and paste special, values only, into a new column.
Then use the "Text to Columns" feature in the data tab of the ribbon and immediately click finish.
You will end up with valid dates that excel will recognize. It is inelegant and a cloogey, but it appears to work.
Last edited by CO#; 05-07-2014 at 06:01 PM. Reason: grammar
You can do that by formula
=--SUBSTITUTE(A1," ","/")
or you can select range, press Ctrl+F in Find press space bar click on Replace and type in / and press replace all.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks