Tricks to Format cells in Excel: Date Format

CA Rishabh Pugalia (ExcelNext) , Last updated: 08 February 2017  
  Share

Lets 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, Select the entire range of cells Right click

You have reached daily limit of 2 Free Articles. To view this or other Articles please subscribe to CCI PRO :

GST Plus

Stay updated! Stay ads free

Browse CAclubindia ads free.
Latest updates on WA.
Daily E-Newsletter and much more.

CCI PRO annual subscription :

Original Price : INR 2999/-

Offer Price : INR 1999/-

Duration : 1 year
(Prices Inclusive of GST)


Know More

Note: If you are a PRO member already, please click here to login (for ad free experience)

CCI Pro

Published by

CA Rishabh Pugalia (ExcelNext)
(Trainer)
Category Students   Report

Other Articles  
Comment   Share
3 Likes   35750 Views
Comments

Related Articles


Loading


Popular Articles




CCI Pro
Meet our CAclubindia PRO Members
Subscribe Now

Trending Online Classes

view all classess

Follow us

CCI Articles

You can also submit your article by sending to article@caclubindia.com

submit article

Browse by Category