<div>
You could format the cells as customer format &quot;yyyymmdd&quot; and then enter the date like 19/09/2012 and excel will display it in the correct format<br />
<br />
Michael
</div>


You could format the cells as customer format "yyyymmdd" and then enter the date like 19/09/2012 and excel will display it in the correct format

Michael

<div>
Dear Kris,<br />
<br />
Thanks. It's works. I can input the date without enter the &quot;/&quot; or &quot;-&quot; now.<br />
<br />
With regards,<br />
Wataw
</div>


Dear Kris,

Thanks. It's works. I can input the date without enter the "/" or "-" now.

With regards,
Wataw

<div>
<div class="content wysiwyg-content">
Dear Sir,<br />
<br />
When I input the date in Excel like 20120919 without &quot;/&quot; and &quot;-&quot;, the date is not recognized.<br />
<br />
Is there any method can solve it?<br />
<br />
Thanks,<br />
Wataw
</div>
</div>


Dear Sir,

When I input the date in Excel like 20120919 without "/" and "-", the date is not recognized.

Is there any method can solve it?

Thanks,
Wataw

Excel not recognizing date input

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.