Date
 

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

Date
 

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))
--
Gary''s Student - gsnu200736


"jbergsli" wrote:

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

Date
 

.... or =DATE(RIGHT(A1,2)+2000,MID(A1,3,2),LEFT(A1,2)), depending on how you
want your dates to be interpreted.
--
David Biddulph

"Gary''s Student" wrote in message
...
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))

"jbergsli" wrote:

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

Date
 

Data Text to Columns Next Next select Date: MDY Finish


"jbergsli" wrote:

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

Date
 

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

On Thu, 9 Aug 2007 02:04:02 -0700, jbergsli
wrote:

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