Enter 8 x digit figure to return dd/mm/yyyy (with parenthess)

Alan Bartley · Oct 31, 2004

I would like to type a 8 x digit figure into a cell and on the strike
of the enter key the 8 x digit figure would change from 12062004 to
12/06/2004, representing 12th day of June, year 2004.

Thanks in advance

Alan Bartley
Sydney Australia

Dave Peterson · Oct 31, 2004

Chip Pearson has some code that'll do what you want at:
http://www.cpearson.com/excel/DateTimeEntry.htm

Enter 8 x digit figure to return dd/mm/yyyy (with parenthess)

Alan Bartley

Dave Peterson