SHORT DATE or LONG DATE, depending on your preference for a numerical date (ie.Choose the HOME, then the number format drop-down menu ( shown at right) in the NUMBER GROUP.Quick Date Format Change To change date formatting in Excel 2007-2016: 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. New Arrival: Excel 365 Functions & FormulasĮxcel for Office 365 Functions.& Formulas Coming Soon: macOS Big Sur and Adobe 2021