Date: mm/dd/yyyy with no hyphens

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

reformat dates to yyyy/mm/dd 5
Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3
yyyy-mm-dd date format? 3
Excel is seeing the date as dd/mm/yyyy 4
Formula bar shows mm/dd/yyyy. To show dd/mm/yyyy. How? 2
Entering date as MM/DD/YY no longer works, why? 1
convert Julian date to DD/MM/YYYY 7
want formula bar date to be dd/mm/yyyy instead of mm/dd/yyyy.How? 1

Back
Top