Fix Excel displaying dates as serial numbers by changing cell formatting to Date or using Text-to-Columns for bulk data.