How to change the date format to text? Sometimes it's easier to read dates when they are written out, for example "12 July 1996" rather than 12/7/1996. To change the date to a more readable text ...

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.