• Status: Solved
  • Priority: Medium
  • Security: Private
  • Views: 38
  • Last Modified:

how to convert m/d/yyyy to d/m/yyyy

i received an excel file where dates were stored as text and it was m/d/yyyy

my computer setting is d/m/yyyy  

i do not know how to convert that m/d/yyyy to d/m/yyyy

8/4/2015
8/13/2015
8/17/2015
8/19/2015
8/21/2015
8/24/2015
8/25/2015
8/26/2015
8/27/2015
10/23/2015
7/23/2015
8/1/2015
6/2/2015
5/19/2015
12/29/2015
9/16/2015
6/9/2015
8/11/2015
10/21/2015
5/6/2015
5/28/2015
10/13/2015
10/13/2015
EE.xlsx
0
Flora
Asked:
Flora
1 Solution
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
Change the column format to a custom format of type d/m/yyyy
0
 
Rgonzo1971Commented:
Hi,

pls try
=DATE(RIGHT(A2,4),SUBSTITUTE(LEFT(A2,2),"/",""),SUBSTITUTE(MID(A2,FIND("/",A2)+1,2),"/",""))

Open in new window

Regards
EE--4-v1.xlsx
0
 
FloraAuthor Commented:
thanks alot
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now