Change slash separator in date with period in Microsoft Excel 2010

Follow by Email
Facebook
Facebook
Google+
http://www.exceltip.com/excel-keyboard-shortcuts/change-slash-separator-in-date-with-period-in-microsoft-excel.html
SHARE




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 (-).

 

img1

 

Follow below given steps:-

  • Select the cell A2:A6.
  • Press the key Ctrl+1, format cells dialog box will appear.

 

img2

 

  • Go to number tab, select to Custom.

 

img3

 

  • Type date format as dd-mm-yyyy

 

img4

 

  • Click on OK.

 

img5

 

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.

 

 

Please follow and like us:
0


Leave a Reply

Your email address will not be published. Required fields are marked *

To avoid automated spam,Please enter the value *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>