![]() |
#1
|
|||
|
|||
![]()
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 |
Thread Tools | |
Display Modes | |
|
![]() |
||||
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 |
![]() |
elly111sk | Word | 3 | 07-25-2012 06:54 PM |
![]() |
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 |