Converting dates to standard format

[richardthelionheart]

26.05.18
10.05.18
19.04.18
I'm importing dates that look like this. I'm trying to get - 26/05/18 or 26/5/18 or 26/05/2018 or 26/5/2018 Any of these will do as they are all read as dates which I can them convert to the microsoft number for that date. I do not know what format was used in the original "dates" I would appreciate any help as I have tried virtually everything I know for 4 hours trying to solve this.

<colgroup><col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>

 

[Fazza]

what about replacing . with /

So,
select data
CTRL-H
find .
replace /

change all

 

[Dave Patton]

Excel 2010
	A	B
2
3	26.05.18	26-May-18
4	10.05.18	10-May-18
5	19.04.18	19-Apr-18
6
4d

Cell Formulas
Range	Formula
B3	=--SUBSTITUTE(A3,".","-")
B4	=--SUBSTITUTE(A4,".","-")
B5	=--SUBSTITUTE(A5,".","-")

Format to your preference.

 

[richardthelionheart]

Excel 2010

	A	B
2
3	26.05.18	26-May-18
4	10.05.18	10-May-18
5	19.04.18	19-Apr-18
6

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

4d​

Worksheet Formulas Cell Formula B3 =--SUBSTITUTE(A3,".","-") B4 =--SUBSTITUTE(A4,".","-") B5 =--SUBSTITUTE(A5,".","-") <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Format to your preference.

Thanks to both replies. I really appreciate it. Dave's one worked really well.