Understanding risk will help us manage it
Bookmark with:
 |
FREE initial consultation |  |
Secure Online Clients Area |
 |
Worldwide service |  |
Choice Of payments [Fixed Fee or Hourly or Daily rate] +44 (0) 208 209 0835/ 07956877605 |
» MS Excel » how to change the default-date separator from a forward slash to a dot when entering a date into a c
CATEGORY: Excel Keyboard Shortcuts VERSIONS: All Microsoft Excel Versions
Excel recognizes a number as a date by its date format, which uses a slash (/) as a separator, for example, 1/25/2004 is recognized as a date by Excel.
To change the default setting for the date format:
1. From the Windows Start menu, select Settings, Control Panel, and then Regional and Language Options.
2. In Regional Options, select Customize.
3. Select the Date tab, and in the Date separator dropdown list, change the slash (/) to a dot (.).
4. Click Apply and then click OK.
how to change the default-date separator from a forward slash to a dot when entering a date into a c
Changing the default-date separator from a forward slash to a dot When Entering a Date into a CellCATEGORY: Excel Keyboard Shortcuts VERSIONS: All Microsoft Excel Versions
Excel recognizes a number as a date by its date format, which uses a slash (/) as a separator, for example, 1/25/2004 is recognized as a date by Excel.
To change the default setting for the date format:
1. From the Windows Start menu, select Settings, Control Panel, and then Regional and Language Options.
2. In Regional Options, select Customize.
3. Select the Date tab, and in the Date separator dropdown list, change the slash (/) to a dot (.).
4. Click Apply and then click OK.
Practical advice for business
