Microsoft Office Forums YYMMDD to YYYY-MM-DD

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-03-2009, 10:37 AM
Alexander's Avatar
Alexander Alexander is offline YYMMDD to YYYY-MM-DD Mac OS X YYMMDD to YYYY-MM-DD Microsoft Office 2008 for Mac
Novice
YYMMDD to YYYY-MM-DD
 
Join Date: Dec 2009
Posts: 1
Alexander is on a distinguished road
Exclamation YYMMDD to YYYY-MM-DD

A very simple question I guess, but I don't know how to do it, so I ask you. How do I format cells so that if I write 091203 it automatically changes to 2009-12-03? (Dates...)
Reply With Quote
  #2  
Old 01-18-2010, 01:22 PM
BjornS BjornS is offline YYMMDD to YYYY-MM-DD Windows Vista YYMMDD to YYYY-MM-DD Office 2003
Competent Performer
 
Join Date: Jan 2010
Location: Sweden
Posts: 116
BjornS is on a distinguished road
Default

Hi there Alexander,
a truly good and easy solution to this issue probably doesn't exist.

I figured out one way of doing this. Assign a user defined format for the relevant cells. In this you enter the format code: "20"00-00-00 (assuming dates are always starting with 20...

If you enter 091203, the cell will show 2009-12-03, but... the cell will contain the value 91203 and you can not use it for date calculations, it actually just looks like a date.

Another, more difficult solution (but instead with true date format), would be to use VBA. Here is a description of how someone else solved it: http://www.cpearson.com/excel/DateTimeEntry.htm

No solution is really nice. I guess you how to live with some extra typing...

Best regards
Bjorn
Reply With Quote
Reply

Tags
date cell formatting

Thread Tools
Display Modes



All times are GMT -7. The time now is 05:41 AM.


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