In this article, we will learn how to change slash separator in date with period in Microsoft Excel 2010.
To change the slash separator in date with period in Microsoft Excel, we can use Format Cells option.
Format Cells: – We can use this option to change the slash separator in the date with period.
We can find this option with the right click of the mouse, and pop-up will be visible. Then click on Format Cells, or we can use shortcut key Ctrl+1 on the keyboard.
Let’s take an example how we can change the slash separator in date with period in Microsoft Excel.
We have dates in column A with slashes, and we will change the slashes (/) with dashes (-).
Follow below given steps:-
- Select the cell A2:A6.
- Press the key Ctrl+1, format cells dialog box will appear.
- Go to number tab, select to Custom.
- Type date format as dd-mm-yyyy
- Click on OK.
To permanently change the date format, follow the below-given steps:
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 and Regional Options.
Select the Date tab. In the Date separator box, change the slash (/) to a period (.).
Click Apply and OK.
This is the way we can change the slash separator in date with period in Microsoft Excel 2010 and 2013.