» 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:
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Microsoft Windows XP Inside Out
- Learn MS Excel 2002 VBA/XML Programming
- Investing for Dummies, Third Edition
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
No comments have been submitted.
