Help needed in changing date format

Rose roon · #1 07-23-2015, 09:52 PM

Hi,

In a excel sheet I have list of dates, I need to change it to yyyy-mm-dd format, I have tried below options

1) Custom format yyyy-mm-dd
2) Data - text to columns - YMD format
3) Format - date format - English (United Kingdom)

Example
14/11/1995 29/07/2002 01/04/1996 18/09/1997 20/01/2001 01/06/2001 19/03/2004 19/03/2004

After this one two values changed

14/11/1995 29/07/2002 1996-01-04 18/09/1997 20/01/2001 2001-01-06 19/03/2004 19/03/2004
Appreciate your help

Regards,
Rose

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
'Monday to Friday' Date calculation help needed	ballst	Word	10	12-16-2014 09:51 AM
Letter date changes when merging with Excel - not the format, the actual date!	Smallweed	Mail Merge	1	02-07-2014 06:00 PM
changing date format in Bibliography field	elly111sk	Word	3	07-25-2012 06:54 PM
Correct Format needed	TonyB	Mail Merge	3	05-03-2011 01:10 AM
Help needed using the serial number date with sumifs - whole office is stumped	FraserKitchell	Excel	3	01-06-2010 12:24 PM