† Excel 2011 for Mac (and older) use the 1904 date system.
Date Axis formatting is available for the X axis (the independent variable axis) in Excel’s Line, Area, Column, and Bar charts for all of these charts except the Bar chart, the X axis is the horizontal axis, but in Bar charts the X axis is the vertical axis. Download Microsoft Office 2008 12.3 for Mac from our website for free. * “Jan Zero, 1900” is 1 see the Bug section below. This discussion mostly concerns Excel Line Charts with Date Axis formatting. Work with texts, data sheets, presentations and other types of documents in the office suite containing Microsoft products such as Word, an advanced text editor, Excel for modifying CSV files and data tables, PowerPoint for slideshow creation, Entourage, etc. Here is a mapping for reference, assuming UTC for spreadsheet systems like Microsoft Excel: Unix Excel Mac Excel Human Date Human TimeĮxcel Epoch -2209075200 -1462 0 0* 00:00:00 (local)Įxcel ≤ 2011 Mac† -20827581 00:00:00 (local)Įxample Below 1234567890 38395.6 39857.6 3 23:31:30 UTC Hi guys I have a client for whom Ive written an Excel application that interfaces via the serial port to their external device.
