November 25, 2020

How to Apply date format in excel

Let’s say we need to change the format of the cell A2 to Date in the below table. Currently we have entered a random number like 200 in cell A2.

To apply date format in cell A2 press the keyboard shortcut Ctrl+Shift+#.

Or as an alternative process you can click on the cell A2 and in the Home tab select the format you need from the dropdown list in Number Group.

As you can see the number has been converted to a date as 18-Jul-00. Excel has the internal rule to convert a certain data to it’s corresponding value in different format. Let’s not get into the detail to find the mechanism behind how the number 200 converted to the date 18-Jul-00. In place of 200 there can be anything which could be converted to the respective date once the date format is applied to the cell.

Now if you need to choose other date formats then you can right click on the cell A2 and click ‘Format Cells’ to open ‘Format Cells’ pane. Alternatively you can also use the keyboard shortcut Ctrl+1 to  open ‘Format Cells’ pane.

Leave a Reply

Your email address will not be published. Required fields are marked *