|
|
#1
07-23-2015, 09:52 PM
|
|||
|
|||
Help needed in changing date format
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 | |
|
|
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 |
Windows 7 64bit 
Office 2007
Threaded Mode