Different date formats

[alexmols]

Hello all,

i have received an automatically generated file which contains a long list of dates which have two different date formats, unfortunately. Examples of these two formats are:

1-12-2010
1/13/2010 12:23:29 AM

Note:
the first format is d/mm/yyyy
the second format is m/dd/yyyy (hh:mm:ss AM)

Is there a way by which I can get the column next to it, to contain one single date format, preferably dd/mm/yyyy

Thanks in advance,
Alex Mols

 

[jmthompson]

What other topic?

This formula converts 1/12/2010 12:00AM to 12/1/2010

 

[alexmols]

What other topic?

This formula converts 1/12/2010 12:00AM to 12/1/2010

Oh sorry I saw another topic about concatenate and thought you mistposted sorry!

 

[alexmols]

What other topic?

This formula converts 1/12/2010 12:00AM to 12/1/2010

Right, it ook me some time to convert all these formula's to Dutch, as well as change the , to ; (since that is the correct way to seperate with the Dutch excel).

Unfortunately it gives me a #NAME error, which I do not know how to fix

 

[jmthompson]

Concatenate = SAMMENKÆDNING
Left = VENSTRE
Find = FIND
Mid = MIDT

 

[alexmols]

Here is the thing I made from your code:

=TEKST.SAMENVOEGEN(DEEL(C1254;(ZOEK("/";C1254;1)+1);2);"/";LINKS(C1254;(ZOEK("/";C1254;1)-1));"/";DEEL(C1254;(ZOEK(" ";C1254;1)-4);4))

=CONCATENATE(MID(A2,(FIND("/",A2,1)+1),2),"/",LEFT(A2,(FIND("/",A2,1)-1)),"/",MID(A2,(FIND(" ",A2,1)-4),4))

using the dutch wikipage for converting english to dutch excel formulas
http://nl.wikipedia.org/wiki/Lijst_van_Excel-functies

 

[alexmols]

I found the error already, "FIND" should be translated to VIND.ALLES and not to ZOEK ...

Thank you so very much for your help!!!