Date: mm/dd/yyyy with no hyphens

D

dandigger

I was wondering if there was a way I could allow a user to enter a date of
birth as 03141980 and have Excel break it out as 03/14/1980?????? or even
allow them to enter 031480 and have Excel break it out as 03/14/1980? Thanks
in advance. Daniel
 
J

Jason Morin

Bob Phillips and others created a utility you can
download that allows quick entry of dates:

http://www.xldynamic.com/source/xld.QDEDownload.html

Another option would be to key in the day as text (set
the cells to text first), then use a formula in another
cell to convert:

A1: 031480
B1: =TEXT(A1,"00\-00\-00")*1

and format B1 as date.

HTH
Jason
Atlanta, GA
 
Top