Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
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
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
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

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:

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

Best regards
Reply With Quote

date cell formatting

Thread Tools
Display Modes

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 01:32 PM.

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