To change the format of a date value, select the cell and then open the Format Cells dialog box.
The Format Cells dialog box can be
opened by using the following ribbon icon:
Home > Format > Format Cells
Custom Date Codes
There are many built-in custom
formats that you can select from the list, or, you can enter a custom
format code into the Type field. When you enter a custom format code, you have
great flexibility in how you display the month, day, and year. For
example, if you want the show the month name fully spelled out, you would use
code mmmm. If
you want to show the month as a three-letter abbreviation, you would use code
mmm.
Keep Learning & Keep Sharing
Sanjay BAKSHI
No comments:
Post a Comment