Input dates into excell with out typing the blackslash eg 030505
 

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

Input dates into excell with out typing the blackslash eg 030505
 

Only through VBA

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

--

Regards,

Peo Sjoblom

"Bill" wrote in message
...
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...

Input dates into excell with out typing the blackslash eg 030505
 

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