QUESTION : I have a spreadsheet that uses a text file with a date string as the first field. I […]
Tag: date-format
Excel requires dates to be typed in American format
QUESTION : In order to type a literal date into an Excel cell, I currently have to do it in […]
Excel: Cannot get Custom Number Format to work for specific date and time
QUESTION : I’ve been going over this for a while and for the specific date + time format I have, […]
How do I enter dates in ISO 8601 date format (YYYY-MM-DD) in Excel (and have Excel recognize that format as a date value)?
QUESTION : I tried to enter this date in ISO 8601 format (YYYY-MM-DD) in Excel 2010: 2012-04-08, but Excel automatically […]
Excel dates formats
QUESTION : When users enter a date in Excel using this format 19.03.2013, I need the cell to automatically change […]
Convert date format 5/29/2014 12:00:00 AM to 5/29/2014
QUESTION : I have a column with dates in the following format, a timestamp “5/29/2014 12:00:00 AM” — I’ve tried […]