title: convert ten digit number into date excel
body: <p>I have a CSV file which contains some dates. These dates are formatted as 10 digit numbers:<br>
  I have used the formula <code>=TEXT(LEFT(A1,5),"dd-mmm-yyyy")</code> but this returns the wrong date.<br></p>
  
  <p>Then 10 digit numbers are with corresponding correct date:</p>
  
  <pre>
  1410666955 is 14-September 2014
  1413514597 is 17-October 2014
  1433822231 is 9-June 2015
  </pre>
  
  <p>Can anyone help me what formula to use to convert to the proper date?</p>
  
  <p>Thanks to Cha, i've managed to convert the number into a Date.</p>
  
  <p>The number was Unix based and i used the following formula:</p>
  
  <p>=(((A1/60)/60)/24)+DATE(1970,1,1)+(9/24) </p>
  
  <p>The 9/24 is because i live in Melbourne Australia</p>