MobileRead Forums - View Single Post - Dates

BetterRed · 10-09-2014, 07:44 PM

Yes Excel 2007 can parse it, if I tell it how, as in Parsing an ISO8601 date/time (including TimeZone) in Excel

I have too much investment in Excel to consider looking for a new spreadsheet program.

As someone commented in the above link - "(: this should be built in", but the fact is that's it's not. Maybe it is in 2010 or 2013 versions of Excel.

BR

10-09-2014, 07:44 PM	#5
BetterRed null operator (he/him) Posts: 21,635 Karma: 29710510 Join Date: Mar 2012 Location: Sydney Australia Device: none	Yes Excel 2007 can parse it, if I tell it how, as in Parsing an ISO8601 date/time (including TimeZone) in Excel I have too much investment in Excel to consider looking for a new spreadsheet program. As someone commented in the above link - "(: this should be built in", but the fact is that's it's not. Maybe it is in 2010 or 2013 versions of Excel. BR