Date Formate Issue

Closed
akram786
Posts
7
Registration date
Wednesday April 30, 2014
Status
Member
Last seen
June 30, 2014
- Jun 30, 2014 at 05:09 AM
 Blocked Profile - Jul 11, 2014 at 03:25 AM
Dear Friends i have one column of Date in A1 cell
issue is diffrent date formate in Column A1 and i want convert in one formate shap
Expample is ....
Date
11/06/2004
06-02-2004
06-15-2004
01/07/2004
02/07/2004
15/07/2004
07-16-2004

i want show in column B in one date formate tell what i do
thanks

2 replies

Blocked Profile
Jun 30, 2014 at 01:52 PM
OK, use the text function like in the following:

=TEXT(WHATCELL,"dd/mm/yyyy")

Or whatever format you wish.
0
Blocked Profile
Jul 11, 2014 at 03:25 AM
Use the following formula :
=Date(year(A2),month(A2),day(A2))
copy it to the entire column and you will get the same date format in each cell.
0