Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 07-24-2015, 12:37 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Help needed in changing date format Windows 7 64bit Help needed in changing date format Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

I suspect you have text looking like dates.
Could you please post a sample of your data?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 07-24-2015, 12:52 AM
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

Hi,

Thank you , test data attached

Regards,
Rose
Attached Files
File Type: xlsx TestData.xlsx (29.8 KB, 22 views)
Reply With Quote
  #4  
Old 07-24-2015, 01:54 AM
macropod's Avatar
macropod macropod is offline Help needed in changing date format Windows 7 64bit Help needed in changing date format Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,366
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your cells are formatted as text, not as dates; hence the content is text, not dates (dates would be right-aligned).

First, change the cell format to your required date format for all the dates.
Next, input 1 into any other cell, then cut that to put it in the clipboard.
Finally, select all the dates and choose Paste Special>Values>Multiply>OK.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 07-24-2015, 09:52 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Help needed in changing date format Windows 7 64bit Help needed in changing date format Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

A quick way :
Select the first column
Data - text to column - Click Finish immediately ( don't change anything in the wizard)
Do the same for the 2nd range
Now you can custom format as desired
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #6  
Old 07-27-2015, 11:57 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

Thanks Charlie & Paul


Regards,
Rose
Reply With Quote
Reply

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 08:25 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