Download the featured file: https://www.bluepecantraining.com/excel-date-format-wont-change-i-cant-change-excel-date-format/

In this video I explore a problem with dates and times, where Excel will not allow you to change the date/time format. This problem is caused by the dates and times being entered as text values.

The solution is to use Text to Columns to convert the dates and times to numeric values. You will then be able to apply date and time formats in the normal way.

Need pre-built Excel spreadsheet solutions? Try Simple Sheets - over 100 templates covering your personal and work-based needs including Gantt charts, personal budgets, employee scheduling, timesheets and more… https://www.simplesheets.co/a/45451/v7Aj9zMx

By clicking on this link you are helping to support this blog – thanks!
------------------------