title: How to represent a DateTime in Excel
body: <p>What is the best way of representing a <code>DateTime</code> in Excel? We use Syncfusions <a href="http://www.syncfusion.com/products/back-office/xlsio" rel="noreferrer">Essential XlsIO</a> to output values to an Excel document which works great. But I can't figure out how to display a <code>DateTime</code> in a column. Not when doing it myself directly in Excel either. Is it impossible? Do I have to use a separate date and a time column? I really wish I didn't, cause it kind of breaks sorting etc... unless Excel have something clever going on to fix that...</p>