When this is case, then anyway you get texts from web. For me Replace worked, because I have different regional format - for you it is not an option. So:
1. To be on safe side, select column A and format it as General;
2. Into some empty cell in some other column (format General!) enter 1;
3. Copy the cell with number 1 you entered;
4. Select tha range with dates in column A;
5. Right-click on selection and select from drop-down menu Paste Special;
6. In pop-up Paste Special window, check radio button Multiply. Click OK;
7. Format the column A as "dd/mm/yyyy" or simply as Short Date.