Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

migrated from Nov 10 '12 at 22:42

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

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

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

You must log in to answer this question.