Indeed it works. Thank you very much.<div><br></div><div>On the other, the documentation says that the format should be yyyy:mm for monthly date values on page 21 in User Guide.</div><div><br></div><div><div>For dates to be recognized as such, the date strings must adhere to one or other of a set of</div>
<div>specific formats, as follows. For annual data: 4-digit years. For quarterly data: a 4-digit year,</div><div>followed by a separator (either a period, a colon, or the letter Q), followed by a 1-digit quarter.</div><div>
Examples: 1997.1, 2002:3, 1947Q1. For monthly data: a 4-digit year, followed by a period or</div><div>a colon, followed by a two-digit month. Examples: 1997.01, 2002:10.</div><div><br></div><div>Maybe the documentation needs to be updated. </div>
<div><br></div><div>Best regards,</div><div>Bulent Erdemir</div><div><br></div><br><div class="gmail_quote">On Wed, Apr 4, 2012 at 11:23 PM, Rodrigo Alfaro Arancibia <span dir="ltr">&lt;<a href="mailto:ralfaro@fen.uchile.cl">ralfaro@fen.uchile.cl</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Bulent, <br><br>I changed the format of column A. <br>I used mmm-yy and it works fine. <br><br>Best, R<br><br><div class="gmail_quote">
2012/4/4 Bulent Erdemir <span dir="ltr">&lt;<a href="mailto:bulente@gmail.com" target="_blank">bulente@gmail.com</a>&gt;</span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="h5">Hi,<div><br><div>Can&#39;t read date column into gretl. I&#39;ve read the manual, formatted the column as gretl would expect (file is attached). But when I want to read the file I receive and error message saying &quot;can&#39;t make sense of the extra bit&quot;. </div>


<div>It seems, gretl sees the internal excel date value which is a number representing the date value as the number of days since 1/1/1900 (A serial number 1 represents 1/1/1900 internally in Excel). </div><div>Tried many variations with no luck.</div>


<div><br></div><div>Assuming this might be due to local regional settings (which were Turkish) having different date formats, I switched to English (USA) settings and tried, but did not work. </div></div><div><br></div><div>


Any ideas ? 
</div><div><br></div><div>Thanks,</div><div>Bulent Erdemir</div>
<br></div></div>_______________________________________________<br>
Gretl-users mailing list<br>
<a href="mailto:Gretl-users@lists.wfu.edu" target="_blank">Gretl-users@lists.wfu.edu</a><br>
<a href="http://lists.wfu.edu/mailman/listinfo/gretl-users" target="_blank">http://lists.wfu.edu/mailman/listinfo/gretl-users</a><br></blockquote></div><br>
<br>_______________________________________________<br>
Gretl-users mailing list<br>
<a href="mailto:Gretl-users@lists.wfu.edu">Gretl-users@lists.wfu.edu</a><br>
<a href="http://lists.wfu.edu/mailman/listinfo/gretl-users" target="_blank">http://lists.wfu.edu/mailman/listinfo/gretl-users</a><br></blockquote></div><br></div>