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

  • Thread starter Thread starter Alan Bartley
  • Start date Start date
A

Alan Bartley

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
 
You must log in or register to reply here.

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

Help with date format mm/dd/yyyy vs. dd/mm/yyyy 3
Converting a 10 digit serial number to a date of mm/dd/yyyy 7
Returning the month (mmm) from cell in date format dd/mm/yyyy 1
In Excel, how can you format for 4 digit years (MM/DD/YYYY)? 4
how do i convert text to date (mm/yy text to mm/dd/yyyy date)? 1
Entering dates into cells as mm/yy or yy 4
format(EnterDate, "mm/dd/yyyy") 12
Dates in Excel 4

Back
Top