How To

When you enter dates in Excel, they may not look right at first. That’s okay though! Whenever a number or date doesn’t look the way you want in Excel, you just have to format it.

Excel features a special format for dates. Unfortunately, some people find out about how Excel formats dates only after dates hadn’t been entered properly. Perhaps an invoice gets sent out on December 1 instead of January 12 because the day and month were reversed. Or maybe you can’t sort that data you collected because the dates weren’t entered properly.