GST Certification Course

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

Let’s take an example, you have a long set of dates in cells like below.

And you want to change the date format as a dd-mm-yyyy format. So that it can show the date format like 2-Apr-2014, which is easy to read. Normally what we do is,

  1. Select the entire range of cells
  2. Right click and then click on Format cell in excel

But there is a shortcut key for this. Simply press ctrl +1 to format cells in excel.

1. So after selecting the range just press ctrl+ 1.
2. Then select date category and then choose your Date format from the selection pane at the right


Now you have your date as per your required date format. Besides this, there is also another trick if you want to show your date as dd-mmm-yyyy format. Select your range and then press Ctrl+ Shift + 3.

Now your date is properly formatted with one shortcut key. Remember, the shortcut key is Ctrl + Shift + 3 to format a date as a dd-mmm-yyyy format.

Recommended course to learn MS Office tools like Advanced Excel, Charts, PowerPoint Ninja, VBA Macros and Word for Finance Professionals.
Click here: /coaching/584-ms-office-bundle.asp

Canonical link:


3 Likes   10 Shares   27771 Views


Related Articles


Popular Articles

GST Course
caclubindia books caclubindia books

CCI Articles

submit article