YYMMDD to YYYY-MM-DD

		Microsoft Office Forums > Microsoft Excel > Excel
YYMMDD to YYYY-MM-DD

FAQ

Thread Tools

Display Modes

12-03-2009, 10:37 AM

Alexander

Mac OS X

Microsoft Office 2008 for Mac

Novice

Join Date: Dec 2009

Posts: 1

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...)