Previous Topic Next Topic

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 responses

Answer 1 / 2
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.
Answer 2 / 2
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.

Similar discussions

How do i change date format in (dd.mm.yyyy)
Talha -
Catherine -

6 responses
Excel format
D -
sheryljohnson -

1 response
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
enter date in dd-mm-yyyy
sam -
fdibbins -

2 responses
Change Date Format - dd/mm/yyyy HH:MM:SS to mm/dd/yyyy HH:MM:SS
asmfiaz -
Mazzaropi -

2 responses