If the Excel cell format is not changing to a number because the Number formatting is not working, take these steps to fix the issue.

If the Excel Date Filter is not grouping by month, enable grouping dates in the AutoFilter menu, set dates in the proper format, etc.

While Excel's auto-formatting feature helps tidy up your data, it can also unintentionally alter your intended formatting. If ...

Microsoft Excel does not attempt to account for any of these missing dates; instead Excel simply treats dates before 1900 as raw text rather than true dates, thereby avoiding these complicated date ...

Excel for the web now supports conditional formatting, and the interface is easier to use than the desktop edition. Susan Harkins shows you how to use it.

How to Reformat a Date in Excel. When you enter a date in one format on a Microsoft Excel worksheet and then want to change the order of the day, month and year, try accessing the Format Cells ...

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.

Not Using a Recognized Date Format When you enter a value into a cell that Excel recognizes as a date, the number format in the Number group of the Home tab will change to either Date or Custom.

How to Auto-Format the Date in MS Excel. When you create Microsoft Excel spreadsheets that contain one or more columns of dates, you can make things a bit easier if you pre-format your cells to ...

Does Excel auto-format dates in ways you find objectionable? Working at a cellular level can put things right.