Formula to convert string

Hello:

I have (11/29/2013) in cell B1
I want to convert this to 11/29/2013 in Cell B3, please help achieve this.

Let me know if any questions.

Thanks

Riz Momin

hi Riz. more egs would help because whether your dates are in DMY, or DDMMYY determines how short the formula is. i'm going to give you the longer version since i don't know. but if your date regional settings is MDY, then simply:
=--MID(B1,2,LEN(B1)-2)

if not, then:
=DATE(LEFT(RIGHT(B1,5),4),MID(B1,2,FIND("/",B1)-2),SUBSTITUTE(MID(B1,FIND("/",B1)+1,2),"/",""))

format cells to achieve your desired date format