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
 

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
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 11:12 PM.


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