» Change slash separator in date with period in Microsoft Excel
CATEGORY - Excel Dates , Excel Keyboard Shortcuts
VERSION - All Microsoft Excel Versions
If you are one of those people who love to use period instead of / and would like to change the default setting for the date format, perform the following steps:
From Windows, choose Start, Settings, Control Panel, Regional Options.
Select the Date tab. In the Date separator box, change the slash (/) to a period (.).
Click Apply and OK.
Book Store:
Recommended Books:
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Financial Statement Analysis with S&P insert card
- Finance and Accounting for Nonfinancial Managers
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- Analysis of Financial Statements
- Excel Charts
No comments have been submitted.
