Input dates into excell with out typing the blackslash eg 030505

B

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

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
 
Top