Convert Date

Giganews Newsgroups
Subject: Convert Date
Posted by:  er…@peoplepartnersusa.com
Date: 27 Jan 2007

How do I convert a year (YYYY) in a cell to MM/DD/YYYY format?  Is
there a formula that will do this?

Replies