Input dates into excell with out typing the blackslash eg 030505

[Bill]

I want to input dates without typing backslash eg 030505 to represent
03/05/2005? can that be done? if so how? any info would be appreciated...

[Peo Sjoblom]

Only through VBA

http://www.cpearson.com/excel/DateTimeEntry.htm

--

Regards,

Peo Sjoblom

"Bill" <[email protected]> wrote in message
news:[email protected]...
> I want to input dates without typing backslash eg 030505 to represent
> 03/05/2005? can that be done? if so how? any info would be
appreciated...

[CLR]

If you want to use a helper column, you can enter your text "dates" down
column A and put this formula in B1 and copy down........

=(LEFT(A1,2)&"/"&MID(A1,3,2)&"/"&RIGHT(A1,2))*1

Then when finished entering, do Copy > PasteSpecial > Values on column B and
delete column A if desired.............

Vaya con Dios,
Chuck, CABGx3



"Bill" wrote:

> I want to input dates without typing backslash eg 030505 to represent
> 03/05/2005? can that be done? if so how? any info would be appreciated...