J
jbergsli
I'm lazy and when I type the date in a cell I would like to type 080807 and
have it dispalyed as 08/08/07. Any Ideas??
have it dispalyed as 08/08/07. Any Ideas??
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Gary''s Student
You can use a helper cell. If you enter 00807 in A1 as text, then in another
cell enter:
=DATE(RIGHT(A1)+2000,LEFT(A1,2),MID(A1,3,2))
cell enter:
=DATE(RIGHT(A1)+2000,LEFT(A1,2),MID(A1,3,2))
D
David Biddulph
.... or =DATE(RIGHT(A1,2)+2000,MID(A1,3,2),LEFT(A1,2)), depending on how you
want your dates to be interpreted.
want your dates to be interpreted.
T
Teethless mama
Data > Text to Columns > Next > Next > select Date: MDY > Finish
G
Gord Dibben
See Chip Pearson's site for event code to allow quick entry of dates as you
describe.
http://www.cpearson.com/excel/DateTimeEntry.htm
Gord Dibben MS Excel MVP
describe.
http://www.cpearson.com/excel/DateTimeEntry.htm
Gord Dibben MS Excel MVP