title: How to convert number into date-time format in excel ( i have equivalent solution achieved in R)
body: <p><a href="https://i.stack.imgur.com/QMUn1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/QMUn1.png" alt="enter image description here"></a></p>
  
  <p>Referring to the above screenshot, i'm trying to crawl data from Singapore Stock Exchange, which the web content is loaded dynamically from an API call returning json, example <a href="https://api.sgx.com/negotiatedlargetrades/v1.0?order=asc&amp;orderby=contractcode&amp;category=futures&amp;businessdatestart=20191205&amp;businessdateend=20191205&amp;pagestart=0&amp;pageSize=250" rel="nofollow noreferrer">here</a></p>
  
  <p>I'm having some problem with the dates, which is given as a number by the json. For example, <code>1575491760000</code> is supposed to be <code>2019-12-04 20:36:00GMT</code>. </p>
  
  <p>After some trial and error, i've figured solution using R:</p>
  
  <pre><code>as.POSIXct(1575491760000/1000, origin="1970-01-01", tz = 'GMT')  
  # not sure why need to divide the number by 1000 here but i guess this is the way to make it work
  </code></pre>
  
  <p>and the above code does return <code>"2019-12-04 20:36:00 GMT"</code> in R. </p>
  
  <p><strong>However, my question is there a solution to the above conversion in Excel?</strong> I've tried a few different ways but none of them can deal with such long data scenario (date + time format). Appreciated if anyone can provide a specific solution! </p>