Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-23-2015, 09:52 PM
Rose roon Rose roon is offline Help needed in changing date format Windows 7 64bit Help needed in changing date format Office 2007
Novice
Help needed in changing date format
 
Join Date: Jun 2015
Posts: 28
Rose roon is on a distinguished road
Default 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
Reply With Quote
 



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
Help needed in changing date format changing date format in Bibliography field elly111sk Word 3 07-25-2012 06:54 PM
Help needed in changing date format 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:57 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft