Tuesday, February 9, 2010

Change slash separator in date with period in Microsoft Excel

Some times most people 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
at

1 comment:

  1. Michael LengAugust 10, 2018 at 2:35 PM

    That's a very informative article! It helps to save time and operate it with more ease. Thank you so much for your useful article.

    Ctrl + ' (apostrophe) To Fill Cell Formulas Down From The Adjacent Cell Above

    ReplyDelete

Subscribe to: Post Comments (Atom)

Hi Friends, After a long break, I again started to work on this blog with new time-saving techniques and tricks for making the day to day...

  • Multiple Row Filters in Same Sheet
    I was working on my data sheet and countered with one problem I required filters in two row ranges on being specific I want the first fil...
  • Tips to look more profession in Excel
    Excel provides several underline formats to give your spreadsheets a professional look and to make them easier to read at a glance. For exam...
  • Web Page from MS Excel
    If you need to analyze data from a Web site, you might be in for a bunch of tedious retyping. Under the right circumstances, however, Excel ...