format date

[Forestq]

Hi,

I have in column A dates:

31/12/2014
31-11/2013
03/Mar/2014 05:11 AM
04-Jan-2013 07:45

How can I simply in column B select date, to have it one format:
DD-MM-YYYY ?

When I'm using function "DATE" = date(A1;A1;A1)
it didn't work.

 

[Jonmo1]

Try

=INT(A1)

And format the cell with the formula as DD-MM-YYYY

 

[Weazel]

I think there are only 30 days in November so

31-11/2013

might be an issue

 

[Forestq]

INT didn't work, In get error (#value).

The date has format general if it helps.

Maybe I can use macro to convert it??? But how ?