VBA Code For Adding 0 Depending On Cells Amount Of Characters

I'm working with a column that contains dates. The dates are pulled from a system that doesnt always have dates in the format

mm/dd/yyyy => 09/26/2014

but instead sometimes
9/26/2014
or
4/7/2014

i.e., 0's are missing.

I'm looking for a macro that inserts these missing 0's

**So I suppose the criteria should be that if the cell is 9 characters long (including the "/"s), then it adds a 0 as first character**
and
***the cells that are only 8 characters, in that case there would have to be insert 0 again as character 1, and 0 as character 4 (if 0 is already added as first)***

I'll attach a file that contains dates : test.xls‎