Excel Forum

Excel Magic Trick 483:Sort sees Date Serial Numbers, Filter Sees Format or Serial Numbers

Learn how Sort only sees serial numbers for dates, but Filter can see the serial numbers or the Number Format such as Weekday Number Format. Learn about Custom Number Formatting and the TEXT function.

Got a Question? Ask it Here in the Forum.