You can download this Date Format in Excel Template here – Date Format in Excel Template Example #1įirst, we will see a short date and a Long date. When we select the general option, it converted to 2, as shown below. Excel gives the number series for the dates starting from to, which means will store as 1, and will store as 2.

Now we will understand what that number is and what calculation is used by Excel to convert the data into an integer. Once you convert, it will change as an integer value, as shown in the below picture. From the drop-down, select the option General and observe how the date will be converted. Select the date and choose the drop-down list from the Number segment under the Home tab. Select this date and convert this to general or number format, then we will find a number. If we observe the above date, it is in the format of Month-Day-Year. To make you understand better, we will look at the following example. Excel stores the date in an integer format.

Excel functions, formula, charts, formatting creating excel dashboard & others How Excel Stores Dates?īefore getting into the data formats, try to understand how Excel stores dates.

Change language in excel