You can use any of the codes in the following tables: In the Type box, make the necessary changes to the format. The built-in date or time format can't be changed or deleted, so don't worry about overwriting it. In the Type box, you should see the format code matching the date or time format you selected in the step 3. (When creating custom number formats, it's easier to start from an existing format than it is to start from scratch.) In the Category box, click Date or Time, and then choose the number format that is closest in style to the one you want to create. On the Home tab, click the Dialog Box Launcher next to Number. Top of Page Create a custom date or time format The number in the active cell of the selection on the worksheet appears in the Sample box so that you can preview the number formatting options that you selected. To display dates and times in the format of other languages, click the language setting that you want in the Locale (location) box. Formats without an asterisk are not affected by Control Panel settings.

Note: Date and time formats that begin with an asterisk (*) respond to changes in regional date and time settings that are specified in Control Panel. In the Type list, click the date or time format that you want to use. In the Category list, click Date or Time. You can also press CTRL+1 to open the Format Cells dialog box. On the Home tab, in the Number group, click the Dialog Box Launcher next to Number. Again, you can customize the way the time appears in the Format Cells dialog box. Similarly, if you type 9:30 a or 9:30 p in a cell, Excel will interpret this as a time and display 9:30 AM or 9:30 PM. If this isn't what you want-for example, if you would rather show Februor 2/2/09 in the cell-you can choose a different date format in the Format Cells dialog box, as explained in the following procedure. For example, if you type 2/2 in a cell, Excel automatically interprets this as a date and displays 2-Feb in the cell. You can format dates and times as you type. You can display numbers in several other date and time formats, most of which are not affected by Control Panel settings. This default format is based on the regional date and time settings that are specified in Control Panel, and changes when you adjust those settings in Control Panel.

When you type a date or time in a cell, it appears in a default date and time format.

Digital clock in excel file download