» 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 22 Immutable Laws of Branding
- Microsoft Outlook 2002 for Dummies
- Microsoft Office XP Introductory Concepts and Techniques
- Microsoft Outlook Version 2002 Step by Step (With CD-ROM)
- The Guide to Understanding Financial Statements
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
