» Customizing Date Formatting in Excel 2007
CATEGORY - Excel Format
VERSION - Microsoft Excel 2007
1. Select cell A1 in the sheet, and insert the current date by pressing Ctrl+;.
2. Select Home -> Number Format dropdown list (in Number Group) -> Short Date or Long Date
Or press Ctrl+1, select the Number tab, and then select Custom.
3. Clear the Type box.
4. Enter the date format in the Type box, based on to the list of symbols below:
m (Month): Displays the months number, without a leading 0 if the number is lower than 10.
mm (Month): Displays the months number, including a leading 0 if the number is lower than 10.
mmm (Month): Displays the first three characters of the months name.
mmmm (Month): Displays the months full name.
mmmmm (Month): Displays the first character of the months name.
d (Day): Displays the days number, without a leading 0 if the number is lower than 10.
dd (Day): Displays the days number, including a leading 0 if the number is lower than 10.
ddd (Day): Displays the days name as a three character text.
dddd (Day): Displays the days full name.
yy or y (Year): Displays the last two digits of the year.
yyy or yyyy (Year): Displays the full year.

Book Store:
Recommended Books:
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Not-for-Profit Accounting Made Easy
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Financial Peace: Revisited
- Guide to Financial Reporting and Analysis
- The Intelligent Investor: The Classic Bestseller on Value Investing
No comments have been submitted.


