help with date formula

[rjhe22]

hi
im using this formula to convert dates like this 08/26/2011 to 26/08/2011
the formula work for that type of date here is the formula
=RIGHT(LEFT(B3,6),3) & LEFT(B3,2) & RIGHT(B3,5)

but when i get a date like this

8/26/2011 that formula does not work any when i play around with it cant get it.
anyone have any ideas

[rcm]

=date(right(b3,4),mid(b3,4,2),left(b3,2))

[rcm]

26/08/2013

better yet,

=RIGHT("0"&mid(b3,4,2),2)&"/"&right("0"&left(b3,2),2)&right(b3,5)

[rjhe22]

getting a #value as an answer

[Pepe Le Mokko]

Select the date( column) - Data -Text to columns - delimited - Next - Next - Select MDY in the dropdown date format box - Finish

[rjhe22]

sweet as thanks that worked