Our Recommendation for You Search your Query, You can find easily. for example search by book name or course name or any other which is related to your education


Format Date in Excel 2013

Insert and format the Date in Excel cell

As for the dates that you insert into a cell in Excel 2013 then we have a number of ways to insert date. Excel assumes the date and "see" as a number. To display the correct date is necessary to format the cell into which we insert date. By default, Excel will recognize the date and it will automatically format the standard date format.
Date in Excel write in a way so that the data is separated by a slash or a hyphen in the form of 15/07/14 or 07-15-14 or 7-15-14.
In this way, data entry excel will understand that this is a date when we confirm entry into a cell Excel will automatically adjust as the date and aligned with the right edge of the cell.

How to insert the date in Excel cell

Date can be a later modified in a way to select the column or range of cells in which we input the date, click on the cell that contains the date, right-click to open the shortcut menu (popup menu) and select from the list of command Format cells.

How to to edit a date via a shortcut menu by right-clicking mouse
At the newly opened dialog box, choose the Number tab and choose a category Date. In the field Type choose the date format that we want. Another way is to immediately select the column in which we enter the date and set the date format.

How to format a date in Excel

Automatically enter today's Date using Excel functions

If you want to a worksheet that you open every day that you can display the current date and enter it personally when you open the workbook, for insert automatic date it is enough to enter in the cell Excel function =TODAY()

Also using the shortcut key combination or we can insert the current date in a cell.

To insert the current date, press Ctrl+; (semi-colon).
To insert the current time, press Ctrl+Shift+; (semi-colon).
To insert the current date and time, press Ctrl+; (semi-colon), then press the Space, and then press Ctrl+Shift+; (semi-colon).

User Date Formatting in Excel 2013

If you want to format a date a later then the dialog box Format Cells in the category Custom, you set your own user format that Excel 2013 allows. (see picture below)

How to change the appearance date in an Excel cell

Date in Excel you can formatting also, by Excel functions: TODAY, DATE, DAY, MONTH, etc.