Click "OK" to change the cells' type from Text to Date and convert the dates to the proper format. Press "Ctrl-S" to save the spreadsheet.

How to Convert a Date to Hexadecimal. On computers, data is stored using a variety of numerical formats. Many programming languages and applications use hexadecimal notation for numbers.