To change the date to a more readable text format: Right-click on the cell with the date you want to convert into a number, and then go to the Format Cells menu. In the Format Cells, in the Number tab ...

If you are unable to change the date format in Excel, check the cell format, you need to change the cell format. This post will help you do that.

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 Change Date Format in a Google Spreadsheet. Google spreadsheets, like their Microsoft Excel counterparts, give you the power to tailor data to suit your business needs. Numbers, currency ...