title: Format code for a date with time zone in excel
body: <p>I have date value with a time zone.</p>
  
  <blockquote>
    <p>24 Nov 2005 GMT+05:30</p>
  </blockquote>
  
  <p>What is the format code for this custom format in Excel?</p>
  
  <p>I tried <code>dd MMM yyyy</code> with <code>z</code>,<code>zz</code>,<code>zzz</code>, and <code>Z</code> but Excel ignores those options.</p>