Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am trying to convert a date string into a date format the strings look like this

Nov 28, 2005 12:00 AM

and i would like them in the format DD/MM/YYYY i have been trying to find a solution online by using the =DATEVALUE() formulae however keep getting a #VALUE error.

starting to pull my hair out now, so any help would be much appreciated

share|improve this question
    
Do you get an error if you do =YEAR(A1) or whatever your cell is? –  LittleBobbyTables Oct 25 '12 at 14:23
add comment

migrated from stackoverflow.com Nov 10 '12 at 22:42

This question came from our site for professional and enthusiast programmers.

1 Answer

there's a function TEXT that will allow you to get the date in the format you choose.

For your questions TEXT(A1,"dd/mm/yyyy") will give you the format you desire

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.